Convert V_String to Date format

[beatrizmguerreiro]

Hello, 

I need to change this column (type V_string) to Date format. I have checked other posts and tried to replicate solutions, like add formula tool or DateTime tool, but I end up with Null Values. How should I approach this situation?

Hereis an example of my dataset:

01/01/2019
04/01/2019
05/01/2019
08/01/2019
08/01/2019
09/01/2019
10/01/2019
10/01/2019

[Emil_Kos · Accepted solution]

Hi @beatrizmguerreiro,

As it will be easier for you to manage and understand I used date time tool in order to do it:

I wasn't sure if the first two digits represent month or day as it wasn't clear from the example I have created two different versions for you.

If this was helpful please mark my post as a solution!

[beatrizmguerreiro]

Hello @Emil_Kos 

The first 2 digits represent day.

i tried your solution and I got all Null values

[Emil_Kos · Accepted solution]

Hi @beatrizmguerreiro,

Are you sure the date time column refers to the correct column name?

Please check if your date is exactly in the format that you specified:

01/01/2019

My workflow works I just tested it.

[Qiu · Accepted solution]

@beatrizmguerreiro 

A bit different approach with @Emil_Kos 

[beatrizmguerreiro]

We are almost there...

I got this warning messages 

[Emil_Kos]

Hi @beatrizmguerreiro,

You get this error using my or @Qiu workflow?

[grazitti_sapna]

@beatrizmguerreiro  can you possibly share the dataset you are using just for the dates column along with the sample workflow seems like there are some records with date and time as per the error.

Also if you see the error the date time format is in yyyy-mm-dd hh:mm:ss whereas the logic used is %d/%m/%Y for conversion.

Does your dataset include multiple date formats?

Thanks.

[Qiu]

@beatrizmguerreiro @Emil_Kos 
I think both will not work since, his test data contains not only the date also the time.🤔

[Emil_Kos]

Hi @Qiu,

Really good point.

In that case, this should work for @beatrizmguerreiro :

DateTimeParse(Left([date], 10),'%d/%m/%Y')

I have used the left function in order to show only relevant values.