Change date format "1202001" to "2001-01-20"

How do I convert "1202001" to "2001-01-20" string type? I have used the below specified function to change the date format but I am getting Null. Could someone help.

DateTimeParse([XXXXX],"%m%d%Y").

Input date format --> 1202001

Output date format --> 2001-01-20

Developer

Developer Tools

Accepted answers

All comments

_

Hi @Nagaraju_kanna ,

Saw @atcodedog05 solutions and realised I missed something. Indeed you are missing a zero at the beginning of your field, so maybe you can try to padleft your input field so you get that 0 at the beginning and then you can parse the date field

Hi @Nagaraju_kanna

My take on this.

Edit: Even I had few corrections so removed my previous post 😅

Workflow:

Hope this helps : )

date conv -2.yxmd

@Nagaraju_kanna

If you use @atcodedog05's solution in a Multi-Field Formula tool, you can convert the field type as well! You also have the added option of converting multiple date fields if needed.

Cheers!

Phil

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703