Date format m/dd/yy (String) to mm-dd-yy(Date)

[yaminibhola]

I have data in csv file and the date looks like 4/15/2020 as string, I need to change it to 04-15-2020 as date.I tried several ways however everything is giving Null value.Please help.

[fmvizcaino]

Hi @yaminibhola ,

To transform your string into a date, one option is to use datetimeparse function.

Datetimeparse([date],'%m/%d/%y')

It will transform your string into a date (yyyy-mm-dd) and that is the only format alteryx support for dates.

Best,

Fernando V.

[rahul_Kumar_koshika · Accepted solution]

Hi @yaminibhola ,

04-15-2020 (MM-DD-YYYY) is not the valid date format recognized by Alteryx. However, in order to get the desired output we can change the data type to string. Please find attached, workflow that will solve your query.

Input:

Desired output:

 

 

If it works mark it as solution

[Sntrada · Accepted solution]

Hello @yaminibhola 

The attached workflow does this, but please note that Alteryx writes date with the year first. 

[yaminibhola]

Thank you!

[Bharadwaj]

This works. Thanks. I had a similar problem struggling with date time parse. Realized that use of MM and mm can also make a difference. MM is months whereas mm is minutes as per Altreryx. 

[lilybadawy]

please will you upload screenshots of the tiles used and what the custom information is