DateAdd

  • Thread starter Thread starter aubrey
  • Start date Start date
A

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
 
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.
Click to expand...

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 =.
 
Back
Top