I am new to Alteryx.
Eg: If my date is 8/20/2020, My output should come as 08/31/2020.
Solved! Go to 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!
Thanks a lot
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.
I got the same output as required with this formua also.
DateTimeTrim([Created Datetime],"lastofmonth")
Thanks for your help.