Hi,

i would like to ask why i try to collect data within a date range, but it doesnt work properly.
e.g. SELECT A, B, C
     FROM table
     where DateEnt >= Date1 AND DaterEnt <= Date2
But when i try to search it, like '07/14/05', the data come out will included the Yr2004's data, anyone tell me how to solve this problem?
Thanks!

use convert to convert the string to datetime

where convert(datetime, DateEnt) >= Date1 AND convert(datetime,DaterEnt) <= Date2

I would also suggest using BETWEEN ...

you may use this sql str
 SELECT A, B, C
     FROM table
     where DateEnt >= #Date1# AND DaterEnt <= #Date2#
or

SELECT A, B, C
     FROM table
     where DateEnt between #Date1# AND #Date2#

#Date1# is not sql server code. I belive it is VB.

Also be carefull on how you do date compares if you want say <= "10/05/2005" and the actual date value is 10/05/2005 04:30:00 because MS-SQL always stores times unless you set it to 00:00:00 you won't see that particular record if the data your stored has a time stored with it.

10/05/2005 04:30:00 is not <= 10/05/2005
because whats really being done in the compare is
is (10/05/2005 04:30:00 <= 10/05/2005 00:00:00) and the answer is no....