>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.
Anywhere that you could use a VFP function :
1) between(tablename.fieldname, {^1998/01/01}, {^1998/12/31})
2) year(tablename.fieldname) = 1998
SQL :
tablename.fieldname between {^1998/01/01} and {^1998/12/31}
Cetin