DATE CRITERIA

[JINGRAM]

COULD SOMEONE POSSIBLY HELP ME WITH INSERTING THE CORRECT CRITERIA IN A QRY? I HAVE A DATE FIELD (ACTUALLY 4) AND FOR THE 1ST ONE I WOULD LIKE TO ASK IT TO RETURN ANY DATES THAT ARE THAT ARE MORE THAN 7 DAYS OLD.

THEN ON THE NEXT QRY I WOULD LIKE IT TO COMPARE TWO OF THE DATE FIELDS AND HAVE IT ALSO RETURN ANY DATES THAT ARE MORE THAN 7 DAYS OLD.
IT SEEMS PRETTY SIMPLE BUT I JUST CAN'T GET BACK WHAT I NEED.
THANKS FOR ANY HELP
JEN

 

[THoey]

First, please turn off your CAPS LOCK key.

Second, you should be able to do this easily:

SELECT *
FROM MyTable
WHERE MyTable.Date1 < SYSDATE - 7;

Hope that helps... Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...