Hi Mike,

May be your there is a type mismatch on your expression.

I assume that you want to filter the records based on the two dates inputted by the user.

example
form1.text1.value = '04/01/2003'
Form1.text2.value = '04/30/2003'

select field1, field2, ... from table1 where between(datefield, form1.text1.value, form1.text2.value)

May be the data type of your text is not in a date format.

Try to change the select statement to
select field1, field2, ... from table1 where between(datefield, form1.text1.value, form1.text2.value)

If this solution does not work please give me your sample coding.