This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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...
Desired Output Date
2019-03-29 (should show previous business day's date, i.e. Friday's date)
2019-04-05 (should show previous business day's date, i.e. Friday's date)
Then, you need have date add logic to go back x number of days depending on what day of the week it is. And using the holidays I mentioned you can remove those dates from the calc. Multi row formula can also work if you have a list of all applicable dates.
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