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
Asteroide

almeera_0-1671721629011.png

 

Eugenialg
Meteoro

Eugenialg_0-1672171094450.png

 

KORKIS3
Asteroide
Spoiler
KORKIS3_0-1673386859138.png

 

Simple Solution : )

DanielG
Cuásar

solved

 

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

François_Rs
Asteroide
Spoiler
Franois_Rs_0-1673455897490.png

 

TyroneW
Alteryx Alumni (Retired)

Solution: 

TyroneW_0-1673472164339.png

 

 

lucysinclair62
Asteroide

Solution below:

Spoiler
lucysinclair62_0-1673542184831.png

 

Jose_Flores22
Asteroide

my attempt

Jasond2022
Meteoroide

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
Bólido

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 (ツ)