ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

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
Asteroid

Solution Uploaded

LHolmes
Comet

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

 

Spoiler
046 - Solution.PNG
DataHabanero
Comet

Easy peazy

AlexPeacock
Asteroid

My Solution

mdsalmankhan89
Asteroid

here is my solution ! 

Harrylosborne
Asteroid

Bit size!

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
Meteor

This was fairly easily done. 

 

Spoiler
MalluShroomer_0-1619796858277.png

 

Steph_Maddrell
Asteroid

Solution attached!

 

Spoiler
Steph_Maddrell_0-1620941280174.pngSteph_Maddrell_1-1620941339418.png

 

 

Thomas_W
Asteroid

Solution attached