How to get the start date of the Week

• LutzM

  SSC Guru

  Points: 107049

  More actions

  May 27, 2009 at 2:40 pm

  #1001020

  Lynn Pettis (5/27/2009)

  ---

  select dateadd(wk, datediff(wk, 0, dateadd(dd, -1, @ThisDate)), 0);

  Nice one...

  As simple as efficient. 🙂

  Thanxalot, Lynn.

  ---

  
  Lutz
  A pessimist is an optimist with experience.

  How to get fast answers to your question[/url]
  How to post performance related questions[/url]
  Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  May 27, 2009 at 2:43 pm

  #1001023

  lmu92 (5/27/2009)

  ---

  Lynn Pettis (5/27/2009)

  ---

  select dateadd(wk, datediff(wk, 0, dateadd(dd, -1, @ThisDate)), 0);

  Nice one...

  As simple as efficient. 🙂

  Thanxalot, Lynn.

  Curious, where in Germany. My daughter is over there for a week. I think she landed in Frankfurt (sp??).

• LutzM

  SSC Guru

  Points: 107049

  More actions

  May 27, 2009 at 4:03 pm

  #1001081

  @vkoka

  would this solution help (based on one of Lynn's date routines)?

  declare @wk int

  set @wk =22

  select dateadd(wk, datediff(wk, 0, dateadd(dd,(@wk-1)*7,'20090101')), 0)

  /* result

  2009-05-25 00:00:00.000

  */

  ---

  
  Lutz
  A pessimist is an optimist with experience.

  How to get fast answers to your question[/url]
  How to post performance related questions[/url]
  Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]