Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Date Time Function - Prioritization Base on Due Date

Franzil
8 - Asteroid

Good day,

 

I hope you find this message well. I am hoping to get some of your help to finally finish my workflow. I am working with the due dates and will give each prioritization depends on its date (Due Date) and marked as '1' '2' and '3'. if the due date is 1 day from as of date then it will marked as '3' then 2 days from as of date would be '2', so on and so forth.

 

I already have a formula below however, my problem is the exclusion of non-working days, particularly Sunday and Saturday. For instance, if I have a due date of 04/18/2025, which falls on a Friday, the following days are Sunday and Saturday. In this example workflow, it would automatically be classified as priority 1. However, it should actually be priority 3, considering my assigned date is today's date, 04/21/2025, excluding Sunday and Saturday, resulting in only 1 working day.

 

 

Formula:

IF DateTimeDiff([Date Assigned],[Due Date],'days') <2
THEN 3
ELSEIF DateTimeDiff([Date Assigned],[Due Date],'days') =2
THEN 2
ELSE 1
ENDIF

 

Below is the final output that I want to be achieve.

 

Assigned Date     Due Date     Prioritization
4/17/2025           4/17/2025             3
4/17/2025           4/16/2025             3
4/17/2025           4/15/2025             2
4/17/2025           4/14/2025             1
4/17/2025           4/13/2025             1
4/17/2025           4/12/2025             1
4/17/2025           4/11/2025             1
4/17/2025           4/10/2025             1

 

 

Hope someone will help me re on this problem, best and regards.

4 REPLIES 4
Qiu
21 - Polaris
21 - Polaris

@Franzil 
I would use the Generate Rows to generate the date between Assign and Due Dates then exclude the Weekends.

0422-Franzil.png

Franzil
8 - Asteroid

Good day Sir @Qiu , Sorry for the late revert since I am really busy with my work. This is really a great idea and yes this worked on my end. Thank you so much for helping me on this. Godspeed!

Qiu
21 - Polaris
21 - Polaris

Glad it helps.

Franzil
8 - Asteroid

Thank you again Sir.

Labels
Top Solution Authors