String to Date

[Sarath27]

Hi All,

Please find the attachment, I am trying to convert the string to Date. i.e 2023_06_01 should be converted as 2023-06-01.

Thanks in Advance.

Sarath.

[Luke_C]

Hi @Sarath27 

You could use this formula:

DateTimeParse([Field1],'%Y_%m_%d')

[Adriankp · Accepted solution]

Hi Sarath,

You can do this with the DateTimeParse function, but you need to adjust the format to fit your string.

DateTimeParse([Date],"%Y_%m_%d")

%Y = Four digit year

Underscore as separator

%m = One or two digit month

Underscore as separator

%d = One or two digit day

Hope it helps!

[JamesCharnley · Accepted solution]

Hi @Sarath27 

When you're parsing dates you need to match the string format exactly, like so:

with the formula

DateTimeParse([MyDate],'%Y_%m_%d')