I want a column stating the Last date of the month for a particular date

[pranit1997]

I am new to Alteryx.

Eg: If my date is 8/20/2020, My output should come as 08/31/2020.

[lmorrell · Accepted solution]

Hi @pranit1997 

Workflow is attached.

By converting your dates into a date data type, truncating to the first day of the month, adding one month, then finally subtracting one day we can dynamically return the final day of the specified date. The calculation to perform this is below

datetimeadd(DateTimeTrim(DateTimeAdd([Date_Date],1,'month'),'month'),-1,'days')

Hope this helps! 

[pranit1997]

Thanks a lot

[grazitti_sapna]

Hi @pranit1997 , give this a try.

Formula-Datetimeformat(Datetimeadd(Datetimetrim(Datetimeadd(Datetimeparse([Date],"%m/%d/%Y"),1,"month"),"month"),-1,"day"),"%m/%d/%Y")

Thanks.

[pranit1997 · Accepted solution]

I got the same output as required with this formua also.

DateTimeTrim([Created Datetime],"lastofmonth")

Thanks for your help.