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

[Nagaraju_kanna]

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

[atcodedog05]

_

[AngelosPachis]

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

[atcodedog05]

Hi @Nagaraju_kanna 

My take on this.

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

Workflow:

Hope this helps : )

[Maskell_Rascal]

@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