RSS

Re: query for creating report group by weeks (with start date and end date of the week)

Please support our MS SQL advertiser: Programming Forums

query for creating report group by weeks (with start date and end date of the week)

•

Join Date: Feb 2007

Location: London

Posts: 114

Reputation: davidcairns is an unknown quantity at this point

Rep Power: 2

Solved Threads: 8

davidcairns davidcairns is offline

Offline

Junior Poster

Re: query for creating report group by weeks (with start date and end date of the week)

Apr 23rd, 2007

Sorry about the missing parameter, my mistake. The datepart parameter dy represents the Day of the Year (1 to 366), there are a number of other options for this parameter that get various peices of the date. Using wk will get the
week, but it uses Monday as day 1, so it doesn't start on the 1st of January, in fact in 2006 the 2nd was in week 2.

What you did appears to be correct, assuming your data lay between the 15th and 21st of January. Try adding a few other lines and see what happens

DaniWeb Home > Forums > Web Development > Databases > MS SQL > query for creating...

Re: query for creating report group by weeks (with start date and end date of the week)

query for creating report group by weeks (with start date and end date of the week)

Re: query for creating report group by weeks (with start date and end date of the week)