Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Start Free Trial

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
21 - Polaris
cmStuhl
7 - Meteor

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

Labels
Top Solution Authors