Date Formatting

[oracleoftemple]

I'm trying to format a date that comes in as a string in the form mmddyy, e.g., 071318 would be July 13, 2018.  I'm trying to covert to the form yyyy-mm-dd, e.g., 2018-07-13.  I'm using the DateTime tool's Custom option, and I specify the format of the incoming string as mmddyy.  The output looks like this:  2018-01-13 00:07:00.  It looks like it's taking the month and calling it the minutes and the month is defaulting to 01.  Can someone help me get the mmddyy string into a yyyy-mm-dd date format?

[kat · Accepted solution]

Hi @oracleoftemple

In Alteryx minutes are a small m and months a capital. So you just need to change it to MMddyy and it shoudl work.

Kind regards

Kat

[oracleoftemple]

Thanks @kat!