>Hi all,
>
>please see attachment.
>
>

>...where hdocdate > {^2010-01-31}...
>

>
>Fails..
>
>what 's the good command ?
>
>Thank in advance
>
>
>bernhart


Use parameters. ie:

.. where hodcDate > ?

and add adodbparameter with type 135 (datetime).
Cetin