Date Range SSRS

• rdangelo

  SSC Enthusiast

  Points: 104

  More actions

  April 28, 2009 at 6:23 am

  #220669

  I use the following in Reporting Services Server to retrive a date range of all values including the time portion.

  SELECT *

  FROM tblYourTable

  WHERE

  tblYourTable.DateField >= @Date1

  AND tblYourTable.DateField < @Date2 + 1