Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語

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

Sapna Gupta

Done

My solution attached.

Solution Attached

Solved

Jenny Jiang solution

Done

Challenge #46: Formatting a Date from an Integer