Date format

[hf14]

I have date in below format:

0131205

Expected output:

Dec 05, 2013

[alexnajm · Accepted solution]

This would be a Formula tool to format into a date, then reformat the way you want as a string. DateTimeFormat(DateTimeParse("2"+[Data],"%y%m%d"),"%b %d, %Y")