a calculation that gives me last month date with the maximum number of days on that month?

[silvanaweinaug]

How can I create a calculation that gives me last month's date with the maximum number of days that month?

For example, if I run it today (or any day this month), it should give me 12/31/2019 (as a date format), because last month maximum day was 31 ( see image below)

But if I would have run it any day last month, it should give 11/30/2019 (as a date format), because previous last month maximum day was 30 ( see image below)

Thank you,

[KP_DML · Accepted solution]

Hello,

You can get there with a combination of date functions:

ToDate(DateTimeTrim(DateTimeAdd(DateTimeNow(),-1,"month"),"lastofmonth") )

[silvanaweinaug]

thank you