Reporting Period end of Month

[PassION_es]

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.

[OTrieger]

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

[Qiu · Accepted solution]

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

[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.