Naomi,

thanks !

the solution :

hdocdate > #31-Aug-2003#

>>>What do you use to test queries directly in Paradox? Does it have some UI element similar to Access or SSMS?
>>
>>hi Naomi,
>>
>>I USE http://www.shareup.com/downloading-22359.html
>>
>>please see attachment.
>>
>>it's well a date !?
>>
>>bernhart
>
>Can you test a query there? The query that you write in VFP should be exactly the same as you write in Paradox. If this allows you to test queries, then try them there.
>
>Take a look here http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_DB/Q_20786840.html