SQL-Weekly data

• var05

  Hall of Fame

  Points: 3011

  More actions

  December 20, 2012 at 5:54 am

  #272335

  Hi All,

  I have 2 date parameters say :

  Calendar Start Date - 08/15/2012

  Calendar End Date - 08/22/2012

  I wanted to retrieve results of all the days i.e from Aug 13th - 19

  and Aug 20th - 26th

  say my sql table shld look like

  Week Startday-Mon

  08/13 - it shld contain data for thaht entire week from 13-19

  08/20 -from 20-26

  what ever date I select in custom calendar start n end date, the where clause should filter in such a way that display data weekly from the selected parameters.

  Any help?

• Eklavu

  Right there with Babe

  Points: 790

  More actions

  December 21, 2012 at 1:43 am

  #1570786

  here is a good link http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47307

  Once you get the first day of the week add no of days to that with the dateadd function to get the last day of your report.