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-09-27 : 09:19:45
|
| Sam writes "I am trying to select a specific date from an SQL database.My selection statement is as follows: Set recSet = dbsConn.OpenRecordset("SELECT * FROM tableName WHERE dateone < '09/19/2001' AND dateone >= '08/19/2001", dbOpenDynaset)"dateone" is of type datetime in the database, and when i use an sql selections statement in the sql application it selects the right data, however when I use the above line in my application (I am writing a little application in VB) it gives me a run-time error '3464'(data type mismatch). Any kind of help would be greatly appreciated.Thank you, Sam" |
|
|
|
|
|
Selecting date from Sql database