Hi,
you asked me what target database I have. It's a VFP DataBase Container that I try to reach trough MDAC 2.6 drivers.
But my problem seemed to be of my not knowing the syntax to include a date in a query string.
I know the commants to convert dates to strings and vv, but thes commants aren't allowed.
Today I got a tip to write the date like this: {09-27-2001} with the month first and it worked!
Even when my date format is DMY it seems that I can only use the MDY format there.

thanks for your help,
ET