core.noscript.text
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
solved
Formula:
IF Left([date], 1) = "0"
THEN ReplaceFirst([date], "0", "19")
ELSEIF Left([date], 1) = "1"
THEN ReplaceFirst([date], "1", "20")
ELSE [date]
ENDIF
Done
My solution attached.
Solution Attached
Solved
Jenny Jiang solution