>I need to print a report using querying two fields in a table. One of the two fields is a date field. In FoxPro 6.0 the following will work for one date
>
>for tablename.fieldname = {^1998/01/01};
>
>but how do you query for a range between 01/01/1998 and 12/31/1998.
>
>Thank You in advance.

FOR BETWEEN(tablename.fieldname,{^1998/01/01},{^1998/12/31})

-Michelle