Creating Date Range RSS

• • Reply
  

  TheEisdame

  Member

  9 Points

  119 Posts

  Creating Date Range

  Mar 16, 2013 01:31 AM|LINK

  Hello world... I have a .net web app that pulls from sql views and one of my forms is pulling data from the sql tables using the dates in the table.. the issue is i need to pull 2 wks of infomation from table... Here is my code.

  WHERE COMPLETED > dateadd(week, datediff(week, 0, (getdate())), 7) -- as beginning_of_previous_week

  As you can guess i am getting a dounut hole! Can anyone help me with this?

   

  Thanks in advance

• • Reply
  

  oned_gk

  All-Star

  31511 Points

  6431 Posts

  Re: Creating Date Range

  Mar 16, 2013 02:31 AM|LINK

  WHERE COMPLETED > dateadd(dd ,-14,datediff(dd,0,getdate()))
  Programming to simplify, dont look for hard way
  • Edited by oned_gk on Mar 16, 2013 02:34 AM
  • Edited by oned_gk on Mar 16, 2013 02:36 AM
  • Marked as answer by Amy Peng - MSFT on Mar 22, 2013 08:59 AM