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

jdbartosh
8 - Asteroid

Solution Uploaded

LHolmes
9 - Comet

We use this conversion often! Though our century indicator lives in an separate field.

 

Spoiler
046 - Solution.PNG
DataHabanero
9 - Comet

Easy peazy

AlexPeacock
8 - Asteroid

My Solution

mdsalmankhan89
8 - Asteroid

here is my solution ! 

Harrylosborne
8 - Asteroid

Bit size!

Maskell_Rascal
13 - Pulsar

One tool solution!

 

Spoiler
DateTimeParse(IF StartsWith([date], '0') THEN
REGEX_Replace([date], '\b0', '19') ELSE 
REGEX_Replace([date], '\b1', '20')
ENDIF,'%Y%m%d')

Cheers!

Phil

MalluShroomer
7 - Meteor

This was fairly easily done. 

 

Spoiler
MalluShroomer_0-1619796858277.png

 

Steph_Maddrell
8 - Asteroid

Solution attached!

 

Spoiler
Steph_Maddrell_0-1620941280174.pngSteph_Maddrell_1-1620941339418.png

 

 

Thomas_B
Alteryx
Alteryx

Solution attached