| Query searching between 2 dates [message #375082] |
Tue, 24 July 2001 10:35 |
Matt
Messages: 43
Registered: September 1999
|
Member |
|
|
I have this query that allows a user to enter two dates into a text field. The two dates are stored in variables. The database is then supposed to return all the records that fall between those 2 dates. For some reason it doesn't work. Here is the piece of code that is giving me problems:
study_date between To_Date('"+rsGS__v_ExamDt1+"','DD-MON-YYYY') AND To_Date('"+rsGS__v_ExamDt2+"','DD-MON-YYYY')
If I simply hardcode two dates in then it works fine, but I can't do that because the dates will always be different. Any help would be greatly appreciated.
Matt
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
