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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only