Last day of the previous month

[sebenciven]

Hi,

I have these date and I would to obtain the last day of the previous month.

For example: If I have 2024-09-30 -> I would obtain 2024-08-31

I can't use the DateTimeFirstOfMonth(), -1, 'month' because the original date can change in every time.

Thanks to all!

[binu_acs · Accepted solution]

@sebenciven 

[davidskaife · Accepted solution]

Hi @sebenciven 

Try this

DateTimeAdd(datetimetrim([Date],"FirstOfMonth"),-1,"day")

[OTrieger · Accepted solution]

@sebenciven 
DateTimeTrim is the function that you are looking for.
DateTimeTrim([Date],"firstofmonth") first day of the month

DateTimeTrim([Date],"lastofmonth") last day of the month