DateAdd

[aubrey]

Hi,

I trying to used the DateAdd function to show me all records that are 15
days prior to today and earlier. I using the function:
=DateAdd("d",-15,Date()), which does not seem to work.


Any help would be great.

Thanks

 

[KARL DEWEY]

Use
<=DateAdd("d",-14,Date())
or
<=Date()-14

 

[John W. Vinson]

Hi,

I trying to used the DateAdd function to show me all records that are 15
days prior to today and earlier. I using the function:
=DateAdd("d",-15,Date()), which does not seem to work.

That will show you all those records where the field is precisely 15 days ago
(midnight on March 18, 2009).

If you want to see records where the date is LESS THAN OR EQUAL to that date,
use <= instead of =.