Reporting Period end of Month

Hello Alteryx,

Requesting for immediate help.

What is the correct formula to get the end of month of the last period? This is the formula i used however, it resulted to 08-30-2024 instead of 08-31-2024.

Datetimeformat(toDate(DateTimeAdd(DateTimeLastOfMonth(),-1,'month')),'%B %d, %Y')

Thank you.

Date Time

Accepted answers

Qiu

@PassION_es
We need another Fuction "DateTImeTrim" which can get the last day of the month.

0910-PassION_es.yxmd

All comments

OTrieger

@PassION_es have you tried to remove the -1 from the formula?

Qiu

@PassION_es
We need another Fuction "DateTImeTrim" which can get the last day of the month.

0910-PassION_es.yxmd

PassION_es

Thank you @Qiu

PassION_es

@OTrieger , -1 represents the last reporting month which is August.

OTrieger

I'm using a different formula
DateTimetrim([DateTime_Out],"lastofmonth")

PassION_es

okay i will try also this one. Thank you.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703