Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAOne tool solution!
DateTimeParse(IF StartsWith([date], '0') THEN
REGEX_Replace([date], '\b0', '19') ELSE
REGEX_Replace([date], '\b1', '20')
ENDIF,'%Y%m%d')
Cheers!
Phil