>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

Also, the format of your dates should be mm-dd-yyyy.