Hi, I have not found a way to get the previous workday from Alteryx. Am I overlooking something? Is there a way how to calculate this?
How does your data come in? Is it a date format (e.g. 2021-01-01) or just the day name (e.g. Tuesday)?
I've used this to get the date of the next Monday from when the workflow runs:
ToDate(datetimeadd(datetimetoday(),8-tonumber(DateTimeFormat(datetimetoday(),"%w")),"days"))
You should be able to adapt this to get the result you want.
It comes from the Date Time Now tool. I want to calculate what the previous business day was and the business day before that.
Thanks! A bit busy today, will try to include it in my workflow tomorrow
I went for an easy solution: In Excel a static data file that includes the previous business day taking into account the Target holiday calendar.
Needed some static data anyway, so no extra file needed.
Thanks for your help in understanding the Alteryx capabilities better.