Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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 #10: Date Time Calculations

gauravsindhwani18
6 - Meteoroid
‎08-03-2023 10:59 PM

Solution asked to calculate the time lapsed between two dates and used that delta value and save them in separate columns Days, Hours, Minutes, Seconds

 

challenge_10_start_file.yxmd
Reply
0 Likes
Yoshiro_Fujimori
15 - Aurora
15 - Aurora
‎08-06-2023 10:04 PM

My solution.

Spoiler

Workflow

Of course all the formula tools can be merged to one.

Challenge_10_1.png

challenge_10_yf.yxmd
Reply
0 Likes
tdiipo
7 - Meteor
‎08-07-2023 09:51 AM

Completed:

 

Spoiler
Spoiler
Screenshot.png
challenge_10_complete.yxmd
Reply
0 Likes
Tejasvi17
8 - Asteroid
‎08-11-2023 03:54 AM

solution

challenge_10_Solution-Tejasvi.yxmd
Reply
0 Likes
HannahLaughton
8 - Asteroid
‎08-16-2023 08:06 AM

Done!

Challenge #10 Date Time Calculations.yxzp
Reply
0 Likes
gawa
16 - Nebula
16 - Nebula
‎08-18-2023 11:37 PM

Data in input and output are not match. Why??

Spoiler
image.png
Reply
0 Likes
prsdpatil
7 - Meteor
‎08-19-2023 06:58 AM

solution

 

challenge_10_soln.yxmd
Reply
0 Likes
gawa
16 - Nebula
16 - Nebula
‎08-21-2023 03:43 AM

Post with solution file

challenge_10_start_file_gawa.yxmd
Reply
0 Likes
Adrien_Sourdille
8 - Asteroid
‎08-22-2023 01:35 AM
Spoiler
Alt 10.png
challenge_10_start_file.yxmd
Reply
0 Likes
olivier_newman
8 - Asteroid
‎08-24-2023 02:10 PM

The start file has changed a little so the seconds are 41 seconds off.

challenge 10.yxzp
Reply
0 Likes
Live Weekly Challenge