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...
>>
>>
>>
>>
>>
>>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