Date Parameter

• iklektic

  Ten Centuries

  Points: 1236

  More actions

  April 28, 2010 at 10:10 am

  #218279

  Hi everyone, I have a report where the date range is: "BETWEEN DATEADD(MONTH, - 12, @StartDate) AND dbo.DateOnly(@StartDate))". The Parameter is @StartDate. I would like to be able to view the results in the end report, so I have the PARAMETERS!StartDate.Value, how do I add in the negative 12 months?

  The end result would look like "Report for 1/1/2009 - 1/1/2010".

  Thanks in advance!

• Wesley Norton

  SSCrazy

  Points: 2827

  More actions

  May 5, 2010 at 8:44 am

  #1162508

  You'd put something like the following into your field.

  ="Report for dates between " & DateAdd("M",-12,Parameters!startdate.Value) & " and " & Parameters!startdate.Value