January 9, 2013 at 3:19 pm
I have this in a stored procedure (SS2005):
DATEPART(ww,Driver_summary.Dor_date) AS WeekNum
When run for a period of 12/30/12 through 1/5/13, it is returning 53 for the days in 2012 and 1 for the days in 2013. Is there a way to get the function to return the same week number for any given Sunday-Saturday time frame, regardless of whether it falls over a year end?
Thanks,
Paul
January 9, 2013 at 3:26 pm
suggest you search this site (and others) for "Calendar tables"....
weeks are generally peculiar to the industry/company...there is a lot of help out there if you care to read.
regards
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 9, 2013 at 3:41 pm
I appreciate your quick reply. I will do that research. The DatePart() function in Access has arguments that let you control this (specifically the "firstweekofyear" argument). I had hoped SQL Server's did as well and I was just missing it.
January 9, 2013 at 3:47 pm
pbaldy (1/9/2013)
I appreciate your quick reply. I will do that research. The DatePart() function in Access has arguments that let you control this (specifically the "firstweekofyear" argument). I had hoped SQL Server's did as well and I was just missing it.
try this for a start
http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 10, 2013 at 2:13 am
This calendar table might also help you out
January 11, 2013 at 2:00 pm
I just came across this and created a case statement to get around this.
CASE WHEN DATEPART(ww,Driver_summary.Dor_date)=53 THEN 1 ELSE DATEPART(ww,Driver_summary.Dor_date) END AS WeekNum
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply