I'm using many datetime fields in MySQL and I want to create a report that will give me all the records within a date range. What is the easiest way to search for all rows that are between 8-18-04 and 8-25-04? Thanks, Chris