sql for searching in between given dates

reshmisworld · July 25th, 2003, 06:58 PM

What sql query is used to search for records falling betn two dates given.

eg. betweenn 7/20/2002 and 7/25/2003
my date field has dates in this format 7/23/2003 4:03:09 AM

vinyl-junkie · July 26th, 2003, 10:23 AM

Here's how to set up your Where clause:

DateRange >= #7/20/02 4:03:09 AM#
AND DateRange <= #7/23/03 4:03:09 AM#

The whole trick is putting the # sign before and after the date/time string. I notice my databases leave off the century in the date/time field, so I don't know if you need to exclude that or not. You might try and see.

Hope this helps. :)

Pat Wong
http://www.napathon.net/ - Music Around The World
For collecting tips, trade and want lists, album reviews and more.