February 1, 2010 at 5:47 am
Hi,
I need Week Start date and week End date for particular Week and year .
eg. if weeknumber=1 and year 10 and month is current month I should get
StartDate=2/1/2010
EndDate=2/6/2010
if weeknumber=2 and year 10 and month is current month I should get
StartDate=2/7/2010
EndDate=2/13/2010.....etc.
Actually I got week number by using datepart(wk, Date) in Query then I grouped by week number. Now I need start date and End Date for the grouped Week Number.
February 1, 2010 at 5:49 am
Use a calendar table
February 1, 2010 at 6:23 am
Do we have any other way withput using calendar table
February 1, 2010 at 6:32 am
What's your objection to a calendar table ?
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply