Change String to Date Format

[Victouf]

Hi all,

I have a field that contains a string format which I am trying to turn into a date. the format is like : 10.08.21

1) First I tried to use the Select tool to change it to Date but the data that comes out is Null

2) Then I tried the formula tool to replace the "." by "/" but still the problem persists

Any idea what the issue could be or how to solve it ?

Best regards,

Victor

[AngelosPachis · Accepted solution]

Hey @Victouf ,

You will have to use a formula tool with a Datetimeparse function  or a DateTime tool to solve this and convert your string into a date. 

Your date will then appear in a format of "yyyy-mm-dd" which is the format that Alteryx recognises/uses for the date data type.

Hope that helps,

Angelos

[Luke_C]

Hi @Victouf 

I'd suggest bookmarking the below page, I find it very helpful when working with dates

https://help.alteryx.com/20213/designer/datetime-functions