Convert week number to date range

• scottsanpedro

  SSCrazy

  Points: 2130

  More actions

  February 10, 2003 at 4:03 am

  #101379

  Is it possible to change a week number to a date range???

  ie week 5 to 27/01/03 and 2/2/03

  Thanks

  Scott

• David Burrows

  SSC Guru

  Points: 65111

  More actions

  February 10, 2003 at 4:48 am

  #448501

  Not pretty but give you what u want

  declare @d datetime

  declare @w int

  set @d = '2003-01-01'

  set @w = 5

  set datefirst 1

  set @d = @d-(datepart(dw,@d)-1)

  select @d+((@w -1) * 7),(@d+((@w -1) * 7))+6

  Far away is close at hand in the images of elsewhere.
  Anon.