Use Date Time Parse formula to parse date Mon-yy (JAN-20)

[Data_Alter]

What changes I need to make in the formula below to make JAN-19 into 2019-01-01.

Using %b-%y is only giving me 2019-0

Please note I can't use Date Time Parse node. I need to use the Formula Node

[marcusblackhill · Accepted solution]

Hey @Data_Alter !

The formula is fine, the problem is the size of the field, in your example, alteryx put the size as 6, when you transform to date need 10 as size. Only add a select tool before the formula to change data size to 10.

Hope that helps