first date of a specified week

• jma100

  Mr or Mrs. 500

  Points: 576

  More actions

  May 14, 2003 at 5:11 am

  #80723

  Hallo friends

  How can I find the first date of current week.

  Eg

  Today is '2003-05-14'

  First date of this week '2003-05-11'

  Best regards

• NPeeters

  SSChampion

  Points: 12535

  More actions

  May 14, 2003 at 5:29 am

  #457083

  Use the following formula

  
  
  DATEADD(dd, 1 - DATEPART(wd, GETDATE()), GETDATE())
  
  

  Fiddle around with the '1 minus' part and SET DATEFIRST to determine what the first day of the week should be...

• Antares686

  SSC Guru

  Points: 125444

  More actions

  May 14, 2003 at 6:32 am

  #457088

  Just a correction there wd should read dw.

  DATEADD(dd, 1 - DATEPART(dw, GETDATE()), GETDATE())

  However if you want to always get the Sunday date without having to do anything more in your code and no need to worry about datefirst value then do

  (note this also sets the time value of the date to midnight Sunday. To get Monday use 0 instead of -1, Tuesday use 1 and so on).

  DATEADD(wk, DATEDIFF(wk,-1,GETDATE()), -1)