Thank you Reinaldo,

I realy find Plamen's method is good.

Thanks again.


>I have used the following sintaxis:
>
> =sqlexec(conhandler,'select * from dbo.table01 where dos_eff = '"+dtoc(date)+"'",'cursor01').
> the key is to convert date to caracter.....!
>
>
>I hope it helps you