Actualy you should not roll starting date back one day or you will pickup all previous date data excluding midnight.
>Thanks Sergey!
>
>
>>Tracy,
>>
>>You doun't need to change start date but you're correct about moving end date to the beginnig of the next day
>>
>>fielddate >= '05/01/2007 00:00:00' and fielddate < '06/01/2007 00:00:00'
>>
>>
>>>Nevermind, I decided it would be easier to go back one day from the beginning date and foward one day from the endate and do > 04/30/2007 and < 06/01/2007 instead...
--sb--