SQL Statement with Dates in ASP
Database
1
Posts
1
Posters
0
Views
1
Watching
-
I have a field called validfrom and validto inside my Table I want a user to be able to enter two dates and then my page pulls back all the data where there dates fall inside the dates in the DB. something like SELECT * from table where form.date1 and form.date2 fall between "VALIDDFROM" and "VALIDTO" So I have a validfrom date January and a validto date of december in the db in same record but my user types in feb to march as feb to march falls inside the jan - dec period that result is pulled to the broweser? Working with MsAccess and ASP Thanks - Michael Fasani www.michaelfasani.com