|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
BETWEEN date
Hello. I am trying to have a SQL Statement retrieve all the objects between two dates. The data is in an Access database, and I'm using classic ASP for the development.
I was trying the following statement: Code:
strSQL = "SELECT * FROM Finances WHERE DateIncured BETWEEN " & CDate(Request.QueryString("date")) & " AND " & now
Any ideas? |
|
#2
|
|||
|
|||
|
Try
strSQL = "SELECT * FROM Finances WHERE DateIncured BETWEEN #" & CDate(Request.QueryString("date")) & "# AND " & DATE() S- |
![]() |
| Viewing: ASP Free Forums > Database > SQL Development > BETWEEN date |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|