formatDate function

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.

Otherwise directly change 1 to a specific date.
:+1:

2 Likes