In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. 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

vijaydholam
7 - Meteor

Solved!!!

With just formula tool using left function to replace 19/20 and datetimeparse function to format text to date within  if condition.

ChrisCode007
8 - Asteroid

Here is my solution

ed_hayter
13 - Pulsar
Spoiler
ed_hayter_0-1676919129931.png

 

anay_zinje
7 - Meteor

Solved!! 

Have used 1 formula tool and created if statement and datetime parse formula to arrive the solution

Nolan
7 - Meteor

Here is my solution! Always fun playing around with date formats.

Spoiler
Nolan_0-1677274973086.png

 

MRNuckles
8 - Asteroid

Solution

Anand_Parekar
7 - Meteor

Happy to solve the WC challenge - The solution has been uploaded to this post, Ciao.

kmoriarty2
5 - Atom
Spoiler
Alteryx Challenge Screenshot.PNG
Spoiler
 
carol2021
8 - Asteroid

Solution

Towers
11 - Bolide

there was probably an easier way to do this