How to get the 1st and last days of the Last week as a date with assuming that first day of week Is Sunday and end of the week is on Thursday

Help StudioX
,
1

How to get the 1st and last days of the Last week as a date with assuming that first day of week Is Sunday and end of the week is on Thursday

so I want the date of the first week (sunday)
and date of the end of the week (Thursday)

2

@Rawan_Ghurab

You can try this

firstDayOfLastWeek = DateTime.Today.AddDays(-(((DateTime.Today.DayOfWeek + 1) Mod 7) + 7)).Date

ForLastDate = firstdayOfLastWeek.Adddays(4)

Cheers

3

Thank u for your reply but it shows me wrong value

4

@Rawan_Ghurab

May I know which one is showing wrong values

Cheers

5

both , it should print 05.28.2023 and 06.01.2023

but it print 05.27.2023 and 05.31.2023

6

@Rawan_Ghurab

Please use

firstDayOfLastWeek = DateTime.Today.AddDays(-(((DateTime.Today.DayOfWeek + 1) Mod 7) + 7)).Adddays(1).Date

Last remains same

Cheers

7

forv todays date it works but if change the date to test another date show wrong value

8

@Rawan_Ghurab

Please try this one

firstDayOfLastWeek = DateTime.Today.AddDays(-(Cint(DateTime.Today.DayOfWeek)+ 7)).Date

Cheers

9

image

same , wrong value

it showld print 21May and 25 of may

10

@Rawan_Ghurab

Please use this for last sunday…my bad I gave a wrong one

lastSunday = currentDate.AddDays(-Cint(DateTime.Now.DayOfWeek)).AddDays(-7)

Cheers