Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-19 : 10:28:38
|
Jim writes "I want to search my datebase to records created between two dates. The datetype for the record is set to datetime and a default vaule of getdate() is entered when the record is created.
Now when I try to search I don't get any errors, but I return all records.
I use the followin sql command
select searchfields from table where createdate >= fromdate and createdate <= todate
any ideas??
thank for you help.
Running SQL 7 on Windows 2000 Advance server with service pack 1" |
|
|
|
|
|
Searching a Date Range