AccessXP
IS-IT--Management
- Jan 29, 2002
- 132
I am trying to find dates 21 days and older. Can someone help.
Thanks.
Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Date search
- Thread starter AccessXP
- Start date
- Status
travisbrown
Technical User
- Dec 31, 2001
- 1,016
SELECT ID FROM tbl WHERE yourdate <= DATEADD("d",-21, DATE())
- Status
Similar threads
- Locked
- Question
- Locked
- Question
