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



asp vbscript date formatmediumdate formatdatelong


Back To Top
© 1998 - 2017 psacake.com | My3C's

Version 7.2 | Advertise on this site