Finding Beginning of the week by specifying what day is the beginning of the week

• skb 44459

  SSCarpal Tunnel

  Points: 4768

  More actions

  May 31, 2013 at 11:33 am

  #293950

  Function should let me select whats my beginning of the week is.

  If i select my beginning of week is thrusday .

  5/30/2013 returns 5/30/2013 which is thruday

  5/31/2013 returns 5/30/2013 which is thruday

  6/1/2013 returns 5/30/2013 which is thruday

  6/2/2013 returns 5/30/2013 which is thruday

  6/3/2013 returns 5/30/2013 which is thruday

  6/4/2013 returns 5/30/2013 which is thruday

  6/5/2013 returns 5/30/2013 which is thruday

  6/6/2013 returns 6/6/2013 which is thruday

  6/7/2013 returns 6/6/2013 which is thruday

  6/8/2013 returns 6/6/2013 which is thruday

  Example

  If i choose Thrusday as my begnning of week then it should

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  May 31, 2013 at 11:40 am

  #1620183

  How about starting here and see if you can figure it out based on what is there:

  http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/

  If you have any questions, come back here and ask.