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
community Alteryx IO MyAlteryx
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
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

richmondbound
8 - Asteroid
‎02-10-2023 06:24 AM

RMNDBD

 

richmondbound_0-1676038997728.png

little more convoluted than the Alteryx based solution, could've optimized with specific formula being more efficient but learning this is good!

 

 

challenge_46_ks_solution.yxmd
Reply
0 Likes
lyon_abido
8 - Asteroid
‎02-10-2023 02:30 PM

Very fun!

challenge_46_solution.yxmd
Reply
0 Likes
Colintermeer
8 - Asteroid
‎02-14-2023 03:01 AM

Answer

challenge_46.yxmd
Reply
0 Likes
Kiwi_Li
8 - Asteroid
‎02-14-2023 01:50 PM

Easy and Interesting to do!

 

Spoiler
Kiwi_Li_0-1676411394726.png

 

challenge_46_Kinley_Ly.yxmd
Reply
0 Likes
greegotr
7 - Meteor
‎02-15-2023 05:30 AM

SOLVED using a FORMULA where I'm creating a new column called DateTime_Output, Data Type = Date, and a formula using the LEFT, DateTimeParse, and RIGHT functions

Reply
0 Likes
aravindarajan90
5 - Atom
‎02-15-2023 05:53 AM

Completed 

Reply
0 Likes
Shahbaz_analyst
8 - Asteroid
‎02-15-2023 06:59 AM
Spoiler
Shahbaz_analyst_0-1676473172610.png

 

challenge_46_start_file.yxmd
Reply
0 Likes
MartinNiedziejko
6 - Meteoroid
‎02-15-2023 07:16 AM

Challenge complete

Reply
0 Likes
Minsu
7 - Meteor
‎02-15-2023 10:03 PM

Here is my solution!

challenge_46_ms_solution.yxmd
Reply
0 Likes
Kusk
8 - Asteroid
‎02-16-2023 07:09 AM

Challenge Completed

Alteryx.zip
Reply
0 Likes