SQL in Dataenvironment

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??:(

Yeah.

Please note that the .text property is set to NULL when the focus is not on the specified control. When the focus has been moved from a textbox the .value property is set.