The VFP OLE DB provider supports CAST() function.

>
>I had thought of that but unfortunately the remote database is a VFP and hence cannot use the CAST function. I should have made that clearer, sorry. Any other ideas?
>
>>>

ltDt = CAST(Null AS datetime)