community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

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

Hi,

 

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

Meteor

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

Bolide

as an alternative you can use datetimeformat:

 

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

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

Labels