Current date minus one business day

[Saravanan13]

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

[Prometheus]

This post has several different ways to solve your problem: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Business-Day-formula/td-p/4845... 

[PhilipMannering]

This should get you what you need,

[PhilipMannering]

FYI, if you're input comes in as a static string then you can use,

DateTimeParse([Input_Field], '%m/%d/%Y')

To first convert it to a date. See attached 

[Saravanan13]

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.