Get the previous business day in a calendar? Please note that I need to consider if the previous day is a weekend. So if today is Monday, what I need to get is the Friday last week

Help Studio
,
1

Hi Team,

get the previous business day in a calendar? Please note that I need to consider if the previous day is a weekend. So if today is Monday, what I need to get is the Friday last week

2

Hi @428e10c08f35f5a9e7b4cece6

Check out this docs

Regards
Gokul

3

HI @428e10c08f35f5a9e7b4cece6

Check out this expression

If(Now.AddDays(-1).DayOfWeek.ToString="Sunday",Now.AddDays(-3).DayOfWeek.ToString,Now.AddDays(-1).DayOfWeek.ToString)

image
image962×310 18 KB

Hope this helps

Regards
Sudharsan

4

If you want as date

If(Now.AddDays(-1).DayOfWeek.ToString="Sunday",Now.AddDays(-3).ToString("dd.MM.yyyy"),Now.AddDays(-1).ToString("dd.MM.yyyy"))

image
image1053×219 14 KB

Regards
Sudharsan