Alteryx Designer Desktop Discussions

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

Min date prior today plus 14 days excluding weekends datetimediff

Ultralightbeam
8 - Asteroid

Hello guys

I have a minimum date (from summary tool) which gets the minimum date from my data. Now goal is to get the range between the minimum date to current date + 14 days (two weeks) excluding weekends

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@Ultralightbeam 
Hope this is what you need.

Capture01.PNG

Ultralightbeam
8 - Asteroid

Hi @Qiu 

 

but how can we make the count of 14 days should include weekends. 14 days of working days only.

Qiu
21 - Polaris
21 - Polaris

@Ultralightbeam 
I made a little modification.

I added 20 days, then exclude weekends.

Capture02.PNG

Labels