Query date range

kpop · Web Design Newbie Joined: Jul 12, 2004 Posts: 11

I have a Date/Time field that has a date and time as the data in the field, in a table that I want to run a query on returning records that are in a date range.

What would the select statement be to return the records in the date range just by date so any record in that date range will be returned regaurdless of its time

ci5co · Web Design Newbie Joined: Aug 18, 2004 Posts: 89

to return records for a particular day, when the datetime field contains datetime values with a non-zero time component, use this pattern:

... where datefield >= '2006-01-22' and datefield < '2006-01-23'

not that one end point is greater than or equal, while the other is less than only
_________________
White Papers

Internet Marketing

Boku