Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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