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-03-18 : 18:48:35
|
Kasper writes "How can I compare dates in a SQL Server 7.0 Database to the actual date within a querystring?
daoRecord.open "Select EndDate from Table where Table.EndDate <='" & Date & "'", daoconn, 0,1
When I open the recordset I get the message that the datetime is out of range. Would it be possible to convert de date in the Table to the way the actual date is written?" |
|
|
|
|
|
querystring with a date