community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Date conversion. German.

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

 

 

Bolide

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

Help1.PNG

Pulsar
Pulsar

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.

Meteoroid

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

Labels