Skip to Content
Former Member
Mar 29, 2010 at 08:12 PM

Use a Parameter or Formula in the Date() function


I am trying to filter a result set utilizing the Date() function. I am trying to get all of the data between June 1st of a given year, and a parameterized date. Here is the formula

{ReportStatic.rpsActualSaleDate} >= Date({@fPrevioustoLastYear}, 7, 1)

and {ReportStatic.rpsActualSaleDate} < DateAdd("yyyy", -2, {?pDateEnd})

and {ReportStatic.rpsSaleStatus} = 1

The value of fPrevioustoLastYear is '2008'

The report is returning 0 records. I think it is because the Date() function isn't recognizing the formula (fPrevioustoLastYear) as a valid input. However when I "Save and close" the formula editor doesn't find any problems with the formula.

What should I be doing differently?