formatDate function

[Ken_Walton]

Hi all, I am trying to extract a date for the last day of the previous month from the current date. I am using the addMonth -1 function with formatDate as YYYY-DD-01 for the first date of the month but that doesn’t work for the last day of the month - please point me in the right direction here?

[ladla_karan]

Hey, this could cause issues as not every month might have 31st.

Try formatDate to fetch 1st of current month and subtract 1 day out of it.

Formula:

{{addDays(formatDate(now; “YYYY-MM-01”); -1)}}

[dilipborad]

Hello @Ken_Walton,
This is a formula for setting the previous month’s 1st date.
{{setDate(parseDate(addMonths(now; -1); "YYYY-MM-DD"); 1)}}

If you need to get the last day of the month and the number of days in the month is not fixed then use this as a reference.

Filtering between first day and last day of month

Welcome to the Make community! You can use the built-in functions setDate, setHour, setMinute, and setSecond to get the first day of this month. [Screenshot_2024-04-18_080448] For the last day of this month, it is a similar formula with two more built-in functions addMonths and addDays. This will automatically cater to months ending on different days (28/29/30/31) — which I have used here How to schedule scenario for the last day next month (recurring) [Screenshot_2024-04-18_080420] Outp…

Otherwise directly change 1 to a specific date.

[Ken_Walton]

@ladla_karan

{addDays(formatDate(now; “YYYY-MM-01”); -1)}}

Thank you - that worked