date-format

[ohruud]

Hi there,

I am trying to concert som data into a date-datatype, but for some reason, the conversion changes the format. 

It is a excel file that bring in the data as string, and the format of the date is dd.mm.yyyy.  When I covert the data into a date-datatype, it changes the order, and returns yyyy-dd-mm.  

I used the formula tool with this formula:   DateTimeParse([Dat],"%d.%m.%y")

Thanks in advance

[ohruud]

Hi,

Yes, YYYY-MM-DD is the format alteryx uses:)