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...
>
>
>
>
>
>Datetime range in sql server 2000/2005. I want to pull records from the earliest minute of the beginning date to the last minute of the end date for example, if the user wants to run a report from:
>
>5/01/2007 through 5/31/2007
>
>it would be: fielddate >= '05/01/2007 00:00:00' and fielddate < = '05/31/2007 23:59:59'
>
>right?
>
>How can I determine what the valid condition would be based on the dates entered in Date() format? I need to catch everything in sqlserver from the 1st minute/second of date1 through the last minute/second of date2...
>
>so:
>
>tdate1 = {05/01/2007}
>tdate2 = {05/31/2007}
>
>I need to convert to
>
>'05/01/2007 00:00:00'
>'05/31/2007 23:59:59'
>
>right? Or am I thinking incorrectly about this...
>
>TIA