SELECT * FROM MyTable WHERE MyDateColumn > #2013-12-01# AND MyDateColumn <= #2013-12-17#
SELECT * FROM MyTable WHERE MyDateColumn BETWEEN #2013-12-01# AND #2013-12-17#
Format
SELECT * from Table where DateField > Format(#@DateField#,'mm/dd/yyyy');
Between
SELECT * from Table where DateField BETWEEN Format(@DateFrom,'dd/mm/yyyy') AND Format(@DateTo,'dd/mm/yyyy')
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)