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
