Week Ending Dates

• dean gross

  SSCrazy

  Points: 2632

  More actions

  March 3, 2005 at 7:48 am

  #74897

  I would like to identify all of the Fridays in a year and then group data into these weeks. Any suggestions would be appreciated.

• Kenneth Wilhelmsson

  SSC-Dedicated

  Points: 30043

  More actions

  March 3, 2005 at 8:06 am

  #545230

  set datefirst 1   -- start weeks on mondays

  select  datecolumn

  from myTable

  where datepart(dw, datecolumn) = 5

  Have a look in BOL at DATEPART for further info on datefunctions.

  /Kenneth