Current date minus one business day

Question

Hello All,

I need a formula to derive previous business date  from current date. Can anyone assist.

Example -

Input

Today's date - 08/21/2023

Output -

Previous business date - 08/18/2023

aatalai · Answer

@Saravanan13  this article can also help https://community.alteryx.com/t5/Engine-Works/Creating-a-List-of-Working-Days/ba-p/1404939

glanyel · Answer

You can change the variable or column input with today's date

e.g.

Switch(DateTimeFormat(DateTimeToday(), '%a'), DateTimeAdd(DateTimeToday(), -1, 'day'),
'Mon', DateTimeAdd(DateTimeToday(), -3, 'day'),
'Sun', DateTimeAdd(DateTimeToday(), -2, 'day'),
'Sat', DateTimeAdd(DateTimeToday(), -1, 'day'))

Saravanan13 · Answer

Hello Prometheus,

Thanks for the reply, But I don't need business dates with in a date range it would be always current date minus one day which should be business date.