querying for date

[dkirk02]

This has got to be sooooo simple!!!!
I just can't get it figured out.
Tbl stores all "requests for service" and "date requested"
Turn around time on filling request is 5 business days. I need to query on requested date and bring back only those that were requested 5 days ago or more.
Obviously (in my mind anyway) I should use the following in the criteria field for the query...
<Date()-4
or
<(Date()-4)
However, neither works.
Any thoughts, ideas?

Thanks in advance,
Deeta

 

[Drew]

Hi Deeta,

<Date()-4 looks right, although either should work, are you getting an error back or just no data?

Drew

 

[DJBummy]

Or Try this one.

<DateDiff("d",4,Now())

both will work

D.J.

[This message has been edited by DJBummy (edited 08-30-2001).]

[This message has been edited by DJBummy (edited 08-30-2001).]

 

[dkirk02]

I think I atleast figured out why it won't query correctly. The data is pulled in from a .csv file where the date is 20010814. Because the date is in this format in the table too, it won't sort it correctly. Silly me. I shall try to import with the correct date format and start at square one!

Thanks