Get the start date and end date based on week number

Learning Hub Academic Alliance
, , , ,
1

HI All

I have a task to get the start date and end date of the week with the given week number

Startdate will be monday end date will be sunday

For example
Week number is 42 means i need dates like
Start date - 10-10-2022
End Date - 16-10-2022

@Yoichi @Rahul_Unnikrishnan @ppr

Regards
Clinton

2

Its urgent , You can give me any kind of solution like vb.net , c# or any expression

Regards
Clinton

3

Hi,

How about the following?

targetYear = 2022
weekNumber = 42
dateJan1 = New dateTime(targetYear,1,1)

Then

dateJan1.AddDays(7*(weekNumber-1)-CInt(dateJan1.DayOfWeek)+1)
dateJan1.AddDays(7*(weekNumber-1)+7-CInt(dateJan1.DayOfWeek))

Sequence.xaml (6.5 KB)

Regards,

1 Like
4

Thank You @Yoichi for the input ,learned something new !

Regards
Clinton

1 Like
5

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