DateTimeParse does not parse leading two digit year

EYamada

I have a string yymmdd and the datetimeparse formula is not parsing the leading two digit year.  Please see details below;

Input:

Field 1

180118

Formula: DateTimeParse([Field1],"%y%m%d")

Conv Error:  DATETIMEPARSE: Cannot convert "180118" to a date/time with format "%y%m%d": Month number is out of range 1..12: '18'

Any thoughts what is going wrong here?

Jonathan-Sherman

Similar to the route @echuong1 wen't down i would add 20 in front of the string and use the DateTimeParse() function:

DateTimeParse('20' + ToString([Field 1]),'%y%m%d')

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

20200117 - DateTimeParse.yxmd