How to get the start and end date for a year and week number, eg YYYYWW?
Hi,
I have an int that holds information about a year and week: YYYYWW, ex:
declare @currentweek int
set @currentweek = 200836
From this, how can I get the start and end date for this week?
PS: I would also like to specify if the week starts with sunday or monday.
Thanks!
I have an int that holds information about a year and week: YYYYWW, ex:
declare @currentweek int
set @currentweek = 200836
From this, how can I get the start and end date for this week?
PS: I would also like to specify if the week starts with sunday or monday.
Thanks!
Pratima
http://database.ittoolbox.com/groups/technical-functional/sql-server-l/get-weekstart-weekend-date-from-week-number-1805281
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Exactly what I needed, many thanks!!