Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAMy solution.
One tool solution.
Function:
IF Left([date],1)="1" THEN
DateTimeParse("20"+Right([date],6),"%y%m%d")
ELSE
DateTimeParse("19"+Right([date],6),"%y%m%d")
ENDIF
Good