Convert V_String to Date format

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

Workflow

Tips and Tricks

Transformation

Accepted answers

Emil_Kos

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!

Date time.yxmd

Emil_Kos

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

@beatrizmguerreiro

A bit different approach with @Emil_Kos

New Workflow11.yxmd

All comments

Emil_Kos

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!

Date time.yxmd

beatrizmguerreiro

Hello @Emil_Kos

The first 2 digits represent day.

i tried your solution and I got all Null values

Qiu

@beatrizmguerreiro

A bit different approach with @Emil_Kos

New Workflow11.yxmd

R_Tristao

The problems faced by Beatriz are exactly the same as they are for me. I am in the same situation and the same errors have appeared.
The Date field which is a V_string, is following the default 01/12/21 (DD/MM/YYYY).