admin
05-28-2003, 11:57 PM
The below code will select records within a date range. Assume you have a date field named 'datum'.
SELECT * FROM Customers WHERE datum BETWEEN #10/01/1999# AND Date()
This will select all records form the Customers table between the dates of 10/1/99 and the current date
SELECT * FROM Customers WHERE datum BETWEEN #10/01/1999# AND Date()
This will select all records form the Customers table between the dates of 10/1/99 and the current date