Filter yesterday's date

Help StudioX
,
1

Hi, my robot filtered yesterday’s date in excel via Filter activity and entered the sequence: datetime.now.AddDays(-1).ToString(“dd.MM.yyyy”)
How to make it filter the date from Friday, Saturday and Sunday on Monday? And not just from Sunday?

2

@sullivanne,

Use this:

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

The screenshot shows code in the immediate window that calculates a date, adjusting for whether today is Monday, and displays it in the format "dd.MM.yyyy", with the resulting date being "14.11.2024". (Captioned by AI)
The screenshot shows code in the immediate window that calculates a date, adjusting for whether today is Monday, and displays it in the format "dd.MM.yyyy", with the resulting date being "14.11.2024". (Captioned by AI)573×188 4.03 KB

3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.