Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Solution below:
Spoiler
Used formula to replace the leading 1 with 20 else the leading 0 with 19. Then used DateTime to convert to standard date. Select for the relevant fields.
Formula:
IF Left([date], 1) = '1'
THEN ReplaceFirst([date], '1', '20')
ELSE ReplaceFirst([date], '0', '19')
ENDIF
Used formula to replace the leading 1 with 20 else the leading 0 with 19. Then used DateTime to convert to standard date. Select for the relevant fields.
Formula:
IF Left([date], 1) = '1'
THEN ReplaceFirst([date], '1', '20')
ELSE ReplaceFirst([date], '0', '19')
ENDIF
