I am trying to use a select statement in the vb6 dataenvironment. I am trying to use a between statement to retrieve records between two dates inputed into text boxes.
ex: select *
from expenses
where [date]between '"txtdate1.text'" and '"txtdate2.text'"
This will not work, and I have tried different ways to express the text boxes with no results. ANY answers??