I hope that someone gives me an answers. I have a simple database and one field is date type. All I need is show a report between to dates. This dates are collected from the user in two text box<br>I been trying with cr4.5, DRD<br>Thank you
The SQL would be something like:<br><br>"SELECT * FROM MyTable WHERE MyDateField BETWEEN " & txt1.text & " AND " & txt2.text & "; "<br><br>Depending on which DBMS you're using, you may have to surround the date parameters with pound-marks ('#').<br><br>Note that the BETWEEN comparison operator (at least in Oracle) doesn't include the endpoints. So if you're looking for dates between 3/1/00 and 4/1/00 you'll get values of 3/2/00...3/31/00<br><br>Chip H.<br>
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.