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 #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