The dates are stored internally as double precision numbers with the integer being the number of days after or before (negative numbers) 12/30/1899 and the decimal is the fraction of the day. So, .5 is noon and .25 is 6 AM and .75 is 6 PM. It is those pesky tiny fractions that may make the Between not work as you expect it to so the >= and <= method is always safer.