How to get the Week number, First, and last day for the given date

[Gokul001 (Gokul Balaji)]

Hi @K_GOWTHAM

This expression will get the Week Number in Integer

CInt(System.Globalization.CultureInfo.InvariantCulture.Calendar.GetWeekOfYear(New Datetime(2023,10,18),System.Globalization.CalendarWeekRule.FirstDay,DayOfWeek.Sunday).ToString)

First Date of the week

New dateTime(Now.Year,1,1).AddDays(7*(CInt(System.Globalization.CultureInfo.InvariantCulture.Calendar.GetWeekOfYear(New Datetime(2023,10,18),System.Globalization.CalendarWeekRule.FirstDay,DayOfWeek.Sunday).ToString)-1)-CInt(New dateTime(Now.Year,1,1).DayOfWeek)+1)

Last date of the Week

New dateTime(Now.Year,1,1).AddDays(7*(CInt(System.Globalization.CultureInfo.InvariantCulture.Calendar.GetWeekOfYear(New Datetime(2023,10,18),System.Globalization.CalendarWeekRule.FirstDay,DayOfWeek.Sunday).ToString)-1)+7-CInt(New dateTime(Now.Year,1,1).DayOfWeek))

Kindly find the video link

Get week number in year?

CultureInfo.CreateSpecificCulture(“en-US”).Calendar.GetWeekOfYear(New Datetime(2021,10,25), CalendarWeekRule.FirstFullWeek,DayOfWeek.Monday) ensure System.Globalization is added to the imports set the locals to your present locals About the week rule enum also have a look here: And here: [grafik] CultureInfo.InvariantCulture.Calendar.GetWeekOfYear(New Datetime(2021,10,25), CalendarWeekRule.FirstFourDayWeek,DayOfWeek.Monday)

Regards
Gokul