Date as a criteria

[joeythelips]

Hi,

I'm running a query that i only want numbers to be returned where the date the number was entered is more than 65 days ago.
My table has 2 fields: Number, Date Entered.


I tried using =[date]-65 in the criteria for the Date Returned Field but no rows were then returned.

Any ideas would be greatly appreciated.

 

[tomschafer]

instead of =[date]-65 try...
Date()-65

 

[joeythelips]

Pezamystik ,

unfortunately i also tried that before and it hasn't worked.
Could or how would, i use the datediff function?

 

[tomschafer]

datediff("d", [Date Entered], Date())=65

 

[joeythelips]

What i reall want to do is not to have to enter a date at all i.e. no parameters boxes

 

[tomschafer]

To clarify- in your criteria use...
=datediff("d", [Column Name], Date())=65

 

[joeythelips]

Just discovered what i'm looking for:
<date()-65
Thanks for helping me get there