Date format is in wazzard format

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

Date Time

Accepted answers

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

Workflow:

Hope this helps 🙂

date change.yxmd

All comments

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

New Workflow3A.yxmd

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

Workflow:

Hope this helps 🙂

date change.yxmd

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.

It worked. Thanks a lot.

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703