User provided date in Query

[Peter]

Hi

I have a couple of questions. I use a database which has
date information in it and I want to find everything (task
related) that will be due any period in the next 2 months
so under the field TargetDate, I put the expression:

<=Date()+60

that works fine. So I thought I could prompt someone to
provide the date they wanted to use instead of the system
date and tried the expression:

<=DateToFind + 60

I am prompted for the date and enter it using the format
dd/mm/yyyy but I always get an error saying that the
expression is too complex.

Any idea what's going on and why it won't work?

Thanks in advance for any assistance.

Peter

 

[Gerald Stanley]

Try
<=Cdate(DateToFind) + 60

Hope This Helps
Gerald Stanley MCSD

 

[Van T. Dinh]

Try:

DateAdd("d", 60, [DateToFind])