Start Free Trial

Alteryx Designer Desktop Discussions

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

Previous Business day and a day before

sourabhsahu94
5 - Atom

Hi I want the previous business day and previous business day -1 below are the examples 

 

Today's dateprevious datePrevious date -1
2021/11/292021/11/262021/11/24
2021/11/232021/11/222021/11/19
2021/11/152021/11/122021/11/11

 

In the first example, 29th Nov was Monday and 26th was Friday but I did not pick 2021/11/25 because it was thanksgiving. Basically, I have a list of dates that holidays and should be excluded from the previous date column and Previous date -1 column as well

 

Note: If holiday value comes pick one day before for both the column

 

Holiday-2021/11/25 

1 REPLY 1
Sebastiaandb
12 - Quasar

Hi @sourabhsahu94 ,

 

Here you go, this should work for you, just alter the table with holidays to your liking :-).

 

Sebastiaandb_0-1638428790132.png

 

 

Greetings,


Seb

Labels
Top Solution Authors