When I used the query designer for a new query and then looked at it in SQL, it actually added quotes around the {}

SELECT COUNT(Retcust.cust_num);
FROM retcust;
WHERE Retcust.c_lastsale > "{12/31/98}"

I got it to work by changing it to this:

SELECT COUNT(Retcust.cust_num);
FROM retcust;
WHERE Retcust.c_lastsale > CTOD("12/31/98")

Thanks for the tip. I didn't realize it was doing that.

Kelly