ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
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 #253: Delivery Dates

almeera
Asteroid

almeera_0-1671721629011.png

 

Eugenialg
Meteor

Eugenialg_0-1672171094450.png

 

KORKIS3
Asteroid
Spoiler
KORKIS3_0-1673386859138.png

 

Simple Solution : )

DanielG
Quasar

solved

 

i seem to be hitting all the datetime formatting weekly challenges as I play catch up.  :)

François_Rs
Asteroid
Spoiler
Franois_Rs_0-1673455897490.png

 

TyroneW
Alteryx Alumni (Retired)

Solution: 

TyroneW_0-1673472164339.png

 

 

lucysinclair62
Asteroid

Solution below:

Spoiler
lucysinclair62_0-1673542184831.png

 

Jose_Flores22
Asteroid

my attempt

Jasond2022
Meteoroid

I didn't read through all the comments, so maybe I wasn't the only one, but I tried to change the Transit Time data type to a time to match Order date and couldn't figure out why none of the formulas I could come up with would work. Started looking at solutions and saw everyone had less tools, but similar ideas to what I originally thought. Then I saw I was over complicating things because Alteryx tends to be very complicated.

 

Anyone else? 

Buehler? Buehler?.....Buehler?

Verakso
Bolide

Sweet nice challenge, but it bothers me a bit. that my result is not in the same order

Spoiler
Workflow, comparison and resultWorkflow, comparison and result
I am not getting the same order of the result, but I do get the same data,

/Verakso (ツ)