Free Trial

Alteryx Designer Desktop Discussions

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

Subtracting Holidays from Business Days

MadeInHB
8 - Asteroid

So I have the business days calculating correctly.  Is there anyway to have alteryx look at a list of dates, see if these dates are in the range (Start Date and End Date) and return a 1 if it is and a 0 if it is not?

 

Example:

 

Start Date is 2/27/2017

End Date is 3/2/2017

Holiday is 3/1/2017.

 

 

21 REPLIES 21
rahulshetty925
8 - Asteroid

Hi Philip,

 

Can you help me with what is the right way to go about doing this task.It will be very helpful.

I just dont want to break the formulas that I have already used.Thank You.

 

Regards,

Rahul

asmith314
8 - Asteroid

Right Click on Workflow Download icon you would normally click on and select Save Link As, then save it to where you want. This worked for me.

Labels
Top Solution Authors