Create a Date Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am a basic user. I am Tracking Training records and need to receate a query
that will find a dates in a field which meet the following critera:
have expired:more than a year from current date
Which will be due within 6 months
or contains a null value

(I am using the medium date format and Access 2000)
 
more than one year ago:

SELECT * FROM TableName
WHERE DateFieldName < DateAdd("yyyy", -1, Date());


due within six months from now:

SELECT * FROM TableName
WHERE DateFieldName Between Date() And DateAdd("m", 6, Date());


contains null value:

SELECT * FROM TableName
WHERE DateFieldName Is Null;
 
Back
Top