Last Calendar Day of Prior Month Formula Not Working - Please help

The formula below is returning "2024 10 30" but I am trying to have the formula return the last "calendar" day of the prior month based on today's date which I am expecting to be "2024 10 31". Can anyone tell me what I am doing wrong?

Datetimeformat(Datetimeadd(DatetimeTrim(Datetimenow(),"Lastofmonth"),-1,"Months"),"%Y %m %d")

Datasets

Accepted answers

alexnajm

You'll have to go to the previous month first and THEN convert to the last of the month (since different months have different ending days)

Datetimeformat(Datetimeadd(DatetimeTrim(Datetimenow(),"Lastofmonth"),-1,"Months"),"%Y %m %d") --> Datetimeformat(DatetimeTrim(DateTimeAdd(Datetimenow(),-1,"Months"),"Lastofmonth"),"%Y %m %d")

All comments

alexnajm

You'll have to go to the previous month first and THEN convert to the last of the month (since different months have different ending days)

RCern

Ahhh so simple. Thank you!!!!

alexnajm

Happy to help!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703