How Do I Take This String and Convert It To A Date?

[mattpeltcfa]

My dates/effective dates are all formatted as "yymmdd", how do I convert this to a date? DateTimeParse and other similar formulas have not been working.

[AbhilashR · Accepted solution]

Hi @mattpeltcfa, you will have to convert yymmdd format into yyyymmdd and then use DateTimeParse. 

Use a formula tool to convert 200336 using a formula.