G
Guest
I'm trying to write a query that gives me a set of dates more than 10 days
old. I want one date to always be the current date and the other will pull
from a date field. if I use =Now()-[Date] and use >10 in the criteria field
i get an error message "Incompatible types in expression (#0)". If I use
#10/27/04#-[Date], it works. Is there any way to get the formula to work
without having to enter the current date but without using "Now()"?
thank you in advance
c
old. I want one date to always be the current date and the other will pull
from a date field. if I use =Now()-[Date] and use >10 in the criteria field
i get an error message "Incompatible types in expression (#0)". If I use
#10/27/04#-[Date], it works. Is there any way to get the formula to work
without having to enter the current date but without using "Now()"?
thank you in advance
c