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

Challenge #46: Formatting a Date from an Integer

ZacharyRyanTIL
Asteroide

solved

Ruban
Asteroide

Formula: 

IF Left([date], 1) = "0"

THEN ReplaceFirst([date], "0", "19")

ELSEIF Left([date], 1) = "1"

THEN ReplaceFirst([date], "1", "20")

ELSE [date]

ENDIF

grazitti_sapna_0-1662098078422.png

 

Sapna Gupta
karlhansen
Cometa
Saqueador
solution_46.jpg
colingreeff
Meteoroide

Done

pmyers
Alteryx
Alteryx

My solution attached.

jomongeorge
Meteoro

Solution Attached

Travis_Ratliff
Asteroide

Solved

jennyjiang
Meteoroide

Jenny Jiang solution

RMdL
Meteoro

Done

Saqueador
RMdL_0-1663664154185.png