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