How to get data yesterday and today by date

[wsinten (KANZ)]

I want to ask, when it is Monday(ddMMyy) it will read Saturday’s date. but when Tuesday, Wednesday, Thursday, Friday, read the date on the same day. What are the appropriate variable contents for the above conditions? Thank You. Please help

[ppr (Peter Preuss)]

Answered:

How to get data yesterday

Assign Activity myDateNew | DateTime = MyDateTimeVar.AddDays(new Double(){0,-1,0,0,0,0,0}(MyDateTimeVar.DayOfWeek)).Date [grafik] within the array we can configure the specific offset for all weekdays For saturday we do use -2

[rlgandu (Rajyalakshmi Gandu)]

@wsinten

If Now.DayOfWeek = DayOfWeek.Monday Then
variable_contents = (Now.AddDays(-2)).ToString(“ddMMyy”)
Else
variable_contents = Now.ToString(“ddMMyy”)
End If

[lrtetala (Lakshman Reddy)]

Hi @wsinten

Please try this

currentDate = DateTime.Now.Date

If currentDate.DayOfWeek = DayOfWeek.Monday
Then
    targetDate = currentDate.AddDays(-2)
Else
    targetDate = currentDate

I hope it helps!!

[Parvathy (PS Parvathy)]

Hi @wsinten

currentDate = DateTime.Now.Date

If currentDate.DayOfWeek = DayOfWeek.Monday
Then
    targetDate = currentDate.AddDays(-2)
Else
    targetDate = currentDate

Note: Datatype of currentDate and targetDate is System.DateTime.

Refer the workflow for more reference:

Sequence17.xaml (9.9 KB)

Hope it helps!!

[ppr (Peter Preuss)]

How to get data yesterday

[grafik] similar to MyDateTimeVar.AddDays(new Double(){0,-2,0,0,0,0,0}(MyDateTimeVar.DayOfWeek)).Date