Today minus one business day

Muhammad

Hi,

I have a date field in my report, which is always the CURRENT date. I need to add another column that shows the previous working day date. Working days are Mon-Fri... Any help would be highly appreciated...

Example:

Current Date	Desired Output Date
2019-04-04	2019-04-03
2019-04-01 (Monday)	2019-03-29 (should show previous business day's date, i.e. Friday's date)
2019-04-08 (Monday)	2019-04-05 (should show previous business day's date, i.e. Friday's date)

danilang

Hi @Muhammad 

Here's a simple workflow that gives what you're looking for.  

The top branch is just your holiday list converted to Alteryx format. The bottom branch start by generating records for 5 days before your input date.  Remove the weekend days, join to the holidays and take the R output that doesn't match a holiday.  Find the max previous day grouped by input day.  I used an text input for the input days but in your case, you can change the generate rows configuration to this to just use DateTimeToday() and remove the lower text input

Dan

PreviousBusinessDay.yxmd