Last date of the month

[sharmilaj]

Hi all,

I'm trying to get the last date of the month from my MMM-YY format. Basically trying to bring the EOMONTH() formula of excel. 

Month	Desired output
Nov-22	30/11/2022
Dec-22	31/12/2022

Kindly help with the formula in Alteryx for this. 

Thanks!

[apathetichell · Accepted solution]

datetimetrim(datetimeparse([datefield]+"01","%b-%y%d"),"lastofmonth")

try that in formation field - where datefield is your datefield in MMM-YY format. Basically this says convert that into a date of the format 3 letter month-2 letter year - date - and then give me the last of month. If you need it formatted in your non-Alteryx/Standardized date way you'd then apply datetimeformat to your date with "%d/%m/%Y" as your settings.