Dertermine the Monday of the Third Week

• rsorrell

  SSC Rookie

  Points: 38

  More actions

  March 17, 2003 at 7:18 pm

  #80474

  What method would you use to determine the the which date is the Third Monday of each Month?

• nigelrivett

  SSCertifiable

  Points: 5472

  More actions

  March 17, 2003 at 8:16 pm

  #451306

  something like

  declare @d datetime

  select @d = '20030101'

  while @d < '20040101'

  begin

  select dateadd(ww,2,dateadd(dd,(9-datepart(dw,@d))%7, @d))

  select @d = dateadd(mm,1,@d)

  end

  Cursors never.

  DTS - only when needed and never to control.

  
  Cursors never.
  DTS - only when needed and never to control.