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-10 : 09:37:09
|
Yello writes "
I want to compare two dates (one actual, and one date that is stored) into MsSql7 database and then select the entries from the database.
I have used this Sql statement
strSQL="Select * From table where MyDate > " &CDbl(CDate(MyNowDate))& " OR MyDate =" &CDbl(CDate(MyNowDate))& " order by MyDate DESC;"
This works, but it doesnt consider entries from today or from tommorrow (meaning the stored Date)
Could someone help me on this ?
Yello" |
|
|
|
|
|
comparing dates