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

[beatrizmguerreiro]

Hello @Emil_Kos and @Qiu 

Indeed. Both solutions worked perfectly!

Thank you very much 🙂

[Qiu]

@beatrizmguerreiro 

Thank you for the accept also.😁

[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).

I'm trying to follow @Qiu's tips, and did the following

I did some tests and they all return the same answer

My intention is to create a column with the date following this format 12/21 (MM/YY)

Best regards

[ddiesel]

Hi @R_Tristao!

This should help:

Or you can combine these two steps into one formula:

DateTimeFormat(DateTimeParse([DATA],"%d/%m/%y"),"%m/%y")

(the data type must be a string, not a date since the resulting mm/yy format is not a date)

Please let us know if this resolves your issue.

Thanks,
Deb