Date()-14

  • Thread starter Thread starter Jacinda
  • Start date Start date
J

Jacinda

Quick question...

I am trying to set up a query in access 2007 that will return all of my
customeers who I shipped to 14 days ago.

This simple function works in my 2003 version, but why can't I get it to
work in 07?
 
Perhaps you have a time associated with the date field.

You might post the SQL of the query you are attempting to run.

Try using

Between Date()-14 and Date()-13

and see if that returns records. If not then try using the DateAdd
function.

DateAdd("d",-14,Date())



'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
 
Back
Top