Dates, previous week data

• hoseam

  SSCertifiable

  Points: 5533

  More actions

  April 14, 2016 at 1:30 am

  #313293

  I'm writing a query that has to return data 7 days or a weekly report. If I run it on Monday, it as to return previous Monday to Sunday data, if I run it on Tuesday or Wed, or Thur or Friday, it still has to return the previous week data.

  Please help.

• J Livingston SQL

  SSC Guru

  Points: 51550

  More actions

  April 14, 2016 at 1:54 am

  #1871909

  does this help at all

  http://www.sqlservercentral.com/Forums/FindPost1774146.aspx

  ________________________________________________________________
  you can lead a user to data....but you cannot make them think
  and remember....every day is a school day

• hoseam

  SSCertifiable

  Points: 5533

  More actions

  April 14, 2016 at 2:09 am

  #1871912

  Thank you so much