We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
alteryx Community

# Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
###### IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

## Challenge #134: US Grand Prix Prelims - Email Dates

Alteryx Alumni (Retired)

I know you guys are as excited as I am for another question from the Grand Prix! This one was also from the prelims for the US Grand Prix. This week, we are focusing on calculating time that has elapsed between emails, but the data need some cleansing first.

Congrats to our Finalists that were announced last week!

17 - Castor
Spoiler
8 - Asteroid

Here's my solution

Spoiler
ACE Emeritus

My solution! Twinsies with speed-demon @patrick_digan... I am starting to think you have a special alarm that notifies you the second the next challenge is posted... :)

Spoiler

Cheers,

NJ

8 - Asteroid

Here's my proposition :

Spoiler
14 - Magnetar

Surely not the clearest way to do it but it works :)

7 - Meteor

Spoiler
Different approach and my datediff was figuring the days on the lesser side so had to convert from hours (datediff of hours) to days in my final formula tool. A lot of tools but this is how I logically think.

Different approach but got there!

18 - Pollux

Nice little lunch time Challenge

Spoiler

Dan

8 - Asteroid

While I did get to the solution, I think there is an error. @JimmyG: If you subtract the dates with time included, you get to different numbers. For example, the first one comes to 14 days instead of 15.

Spoiler

Alteryx Alumni (Retired)

@AGoyal - good catch. We actually found this during testing so we added a hint to not worry about the time.