Using Date Ranges

1. Home
2. SQL
3. Using Date Ranges

The below code will select records within a date range. Assume you have a date field named 'datum'.

SELECT * FROM Customers WHERE datum >#10/01/2013# AND datum < date()

Or

SELECT * FROM Customers WHERE datum BETWEEN #10/01/2013 AND Date()

This will select all records form the Customers table between the dates of 10/1/2013 and the current date