How to get the last day of the previous month in pabbly?

[Lucas.]

Looking for the best way to show the last day of the previous month in pabbly?

 

[Lucas.]

Excel formula is not working in pabbly
=EOMONTH(2022-09-01,-1)

 

[Supreme]

Hey @Lucas.

You can refer to the following screenshot for your work.

 

[Lucas.]

@Supreme, thanks for your reply but the last day of the previous month is 2022-08-31.
This is dependant on the month. September will end 2022-09-30 and february 2023-02-28.

 

[Supreme]

Hey @Lucas.

You can google for another formula for the Spreadsheet or can you use the regular expression for the same which you can use in the Text Formatter by Pabbly : Extract Pattern action step.

 

[Lucas.]

Tried looking, but there is no other formula to find the last day of the month then =EOMONTH(A2,0)
What do you mean by regular expression?

 

[Lucas.]

Solved this by putting the formula in Google Sheets and getting the result in a next step.

Today	END OF MONTH	FIRST DAY OF MONTH
=TODAY()	=EOMONTH(A1;0)	=EOMONTH(A1;-1)+1