How to convert MMM YY(string format) to DD-MMM-YYYY in date format

[jagdeep_singh85]

Hi,

How to convert MMM YY(string format) to DD-MMM-YYYY in date format?

[agentzerow]

left(datetimetrim(DateTimeParse([Input],"%B %y"), 'lastofmonth'),10)

[neilgallen]

as an alternative you can use datetimeformat:

datetimeformat(datetimetrim(DateTimeParse([Month(Input)],"%B %y"), 'lastofmonth'),"%Y-%m-%d")

[jagdeep_singh85 · Accepted solution]

Thanks for help, I have used date time tool with custom "%m/%d/yyyy"