Convert string to Date Jan-50 to see it as 1950-01-01

[Marta12]

Hi, 

I try to use DateTime tool but when I use "Mon-yy" it reading Jan-50 as 2050-01-01 and I'm expecting 1950. This issue disappear reaching date  Jan-55 --> 1955-01-01. Do you know how to repair it? 

[mot]

Hi @Marta12,

I would suggest to add "19" to the string first before converting:

This way, you can ensure that the dates are in 1900s. See the workflow attached. You can then convert using datetime. I hope this helps. Best!

[Marta12]

Thanks, but my data also contain more recent data till 2021. This formula won't work with more recent date. 

[mot · Accepted solution]

Hi @Marta12,

In that case, you can add an if statement to determine if Jan-10 is in 20xx or 19xx. I have added this logic to the workflow. I hope this helps. Best.