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
<><><><><><><><><><><><><><><><><><><><>
<><> REMEMBER,,,,KNOWLEDGE IS POWER <><>
<><><><><><><><><><><><><><><><><><><><>