Alteryx Designer Desktop Discussions

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

Create date that is 25th of current month, but next business day if 25th is on a weekend

cmStuhl
7 - Meteor

Hi All, 

 

The output I am creating in my current workflow must have a date that is 25th of current month, but next business day if 25th is on a weekend. Currently the input date I have to work with will always be 5 days prior to the 25th (20th). Does anyone have a solution to figure out the correct date? 

 

 

Thanks,

Max

2 REPLIES 2
binuacs
20 - Arcturus
cmStuhl
7 - Meteor

Had to change the Sunday to a 6 and Saturday to a 7, but this worked! thank you!

Labels