Date conversion

[EvansM]

Hello,

How do I convert  from YYMMDD to YY/MM/DD

190505    19/05/05

071218     07/12/18

200215     20/02/15

100205     10/02/05

Thanks

[JosephSerpis · Accepted solution]

Hi @EvansM I mocked up a workflow that acheives your desired output. You need to perform a datatime parse of your orginal date time format into the only format Alteryx reconise as date YYYY-MM-DD then perform a datatime format formula to match your desired format which would result in a string field. The added complication was trying to perfrom a straight datetime parse of your data orginal format was, it was throwing errors hence why I build out the date into YY-MM-DD before I parse the date. This link provides more detail around date time functions in Alteryx.

[Emmanuel_G · Accepted solution]

@EvansM 

Find in attachement the way of doing that.

Let me know if there is any issue and please, do not hesitate to mark this answer as solution if it helped.

Bonus : I also parsed your data in correct date format in additional field. 😉

[binu_acs · Accepted solution]

@EvansM One way of doing this