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-05-23 : 00:35:46
|
Alexander writes "Hi ASP-Cracks
Could anyone tell me how to perform a sql-query like:
strSQL = select Date from TBL where Date <= date1 and <= date2
Many different approaches did not work! (data type mismatch and syntax error-messages)
Thank you very much!
Best regards
Alex
Example:
strSQL = strSQL & "SELECT TS_ID, Datum, Teilnehmer, Traktandum, Pendenz, Zeitplan, Erledigt FROM TagesSitzungenTBL " & _
"WHERE Erledigt = False AND Traktandum LIKE '%" & Request.Form("strTrakt") & "%' AND Pendenz LIKE '%" & Request.Form("strPend") & "%' " &_
"and Datum >=(#" & Request.Form("Date1") & "#) and Datum <= (#" & Request.Form("Date2") & "#)" &_
"and Zeitplan <=(#" & Request.Form("Date3") & "#) "" |
|
|
|
|
|
ASP Query between two dates (Access97; PWS)