>I need to gather records from a date field from a range to a range. What I'm trying is not working "where registration.flddate between thisform.text1.value and thisform.text2.value" What wrong with this line of code. I'm getting from vfp "Filter Clear" and "Object is not contained in a form" and all my records are displaying
>
>Thanks Randy

Make your SELECT - SQL command like string and the macrosubstitute it. e.g.:

Local lcSQL
lcSQL = [SELECT * from registration WHERE registration.flddate between ]+ TransformToDate(thisform.text1.value)+[ and ]+TransformToDate(thisform.text2.value)

TransformToDate is your own UDF that makes a given DATE value in appropriate string format for your database (if you use SQL Server it will give some different result than for VFP tables) For that function you may uilize the DATE, DAY, MONTH, YEAR VFP functions.

HTH