In my report I have a date variable named endDate and I'm filtering my results based on anything earlier than that date. What expression can I use to subtract 120 days from endDate? I tried using getdate(endDate) - 120 and other variants to no avail. Any help is appreciated.

Try this - DATEADD(day,120,@endDate)

ttp://i52.tinypic.com/160v1qp.jpg And at runtime it says: "Argument not specific for parameter 'DateValue' of 'Public Function Day(DateValue As Date) As Integer'.

Try using DateAdd("dd",-120,@endDate) Or DateADd("d",-120,@endDate) HTH, Ram

Try using DateAdd("dd",-120,@endDate) Or DateADd("d",-120,@endDate) HTH, Ram This worked: =DATEADD("d",-120,Parameters!endDate.Value) Thank you for your help!