Date format is in wazzard format

[mmustkee]

Hi team,

I receive date in below format. I have been using formula below but no help.

DateTimeParse([m Date], "%Y%m%d")

ToDate([m Date])

Kindly hep.

m Date	C Date	T Date
43872	44228	44277
43872	44228	44278
44286	44286	44294
44286	44286	44294
44273	44273	44291
44273	44273	44291
44273	44273	44291

[Qiu]

@mmustkee 
In order for Todate function to work, the data needs to numeric at first.

[atcodedog05 · Accepted solution]

Hi @mmustkee 

You can use a multi-field method to convert multiple fields into date format.

Workflow:

Hope this helps 🙂

[mmustkee]

Hi Qiu,

Thanks for the solution and it worked too. But lets suppose we have only one date column to change. so can we not use formula function without using Record id, Transpose or cross tab.

Thanks for your response in advance.

[atcodedog05]

Hi @mmustkee 

Yes using ToDate() in a formula tool should work for single column.

Hope this helps 🙂

[mmustkee]

@atcodedog05 

It worked. Thanks a lot.

[Qiu]

@mmustkee 
I am using the combination of Record id, Transpose or cross tab to make the solution dynamic.
so it would also work if you want only change one column and more important is that it will works if the columns increases.