field1 is a date, and the contents of the two variable are two dates dor example:

variable1: 01-01-2000
variable2: 31-12-2000

I want to select all the records betwen this two dates.
In vb i set the two varibles as strings