community Alteryx IO Mission Control
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
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

ferg_smith
8 - Asteroid
‎03-07-2023 06:03 AM
Spoiler
ferg_smith_0-1678197774028.png

 

challenge_46_complete.yxzp
Reply
0 Likes
syahya
8 - Asteroid
‎03-07-2023 09:28 AM
Spoiler
46 Solution.PNG

I didn't like the one formula tool solution with the date expressions, so I split it into separate steps.

challenge_46_solved.yxmd
Reply
0 Likes
jerviss53
8 - Asteroid
‎03-08-2023 05:01 AM

Solution attached

challenge_46_solution.yxmd
Reply
0 Likes
CeliaC_Silje
8 - Asteroid
‎03-08-2023 07:30 AM
Spoiler
CeliaC_Silje_0-1678289403929.png
challenge_46_start_file.yxmd
Reply
0 Likes
bajajankit
7 - Meteor
‎03-10-2023 04:21 AM

a little long method

challenge_46_Solution_AB.yxmd
Reply
0 Likes
michael_apau
8 - Asteroid
‎03-10-2023 06:22 AM

Screenshot 2023-03-10 140830.png

my_solution_challenge_46.yxmd
Reply
0 Likes
JClinton
7 - Meteor
‎03-14-2023 12:37 PM
Spoiler
Spoiler 

Jessshaver_0-1678822602469.png

 

challenge_46_start_file.yxmd
Reply
0 Likes
asimmonz9076
7 - Meteor
‎03-16-2023 02:46 PM

Done.

challenge_46_Aaron.yxmd
Reply
0 Likes
mindyzhang99
8 - Asteroid
‎03-17-2023 09:44 PM

Two approaches but same logic

I prefer the first one as the logic is more clear

The second one is more efficient

mindyzhang99_1-1679114269062.png

mindyzhang99_2-1679114460216.png

 

mindyzhang99_3-1679114576426.png

 

 

 

 

challenge_46_Mindy Solution.yxmd
Reply
0 Likes
aashijain7
5 - Atom
‎03-21-2023 08:01 AM

simple solution

Reply
0 Likes