>Hi Sergey. It is DATETIME() type. Does it need to be handled differently in the BETWEEN() clause?

Think about it! Is the 3rd of June 2008 12:09 PM between 3rd of June 2008 12:00 AM and 3rd of June 2008 12:00 AM? No, it's after midnight, even after noon.

Your not querying a datetime being within a date, the date values are extended with 12 AM, so you would only find if a datetime is exactly midnight of that queried day...

Get it now, why you would add 1 to the end date? It's just so you get a real timespan you will query in.

Bye, Olaf.