[Solved] Subtraction of days from date parameter

[Chicken Head]

Is it possible to have a date parameter in a query and subtact a number of days from it in the same filter?

For example

[DS_Presenation].[Calendar].[Date/Month/Year] >= ?Date? -30

I've tried this but it returns an error.

Many Thanks

Mark

[sir_jeroen]

What db are you using?
Have you looked in the Functions list under help?
You can use e.g. _add_days

Btw make sure you cast the parameter to a date first...

[Chicken Head]

Thanks, the problem was down to not casting the date parameter.