Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Date conversion. German.

Highlighted
6 - Meteoroid

Hi All,

 

I got a question about German date I have it in forma dd.mm.yyyy. And either auto field nor select identify it as a date. I have tried to transform it with a formula replacing . for / and - and then using todate() but it is not working. How have you solved date transformation problem? I would like to have this date in date format.

 

thanks in Advance,

 

Luis

 

 

Highlighted
11 - Bolide

Hi, @luisja, have you tried using the DateTime parsing tool? See attached picture. 

Help1.PNG

Highlighted
14 - Magnetar
14 - Magnetar

Hey @luisja!

 

Try using this expression to create a new field in your formula tool: 

datetimeparse([Field1],"%d.%M.%Y")

Make sure that this new field is a date type. This should transform your strings into Alteryx formatted dates.

Highlighted
6 - Meteoroid

Thanks! I am using this solution as I am able to convert several fields in the same step .

Labels