Edgar,

Is your l_cSQL part of the VALUES clause? Why not use the DATE() function? Or you could stuff date() into a memvar.

>this doesn't work.
>
>l_cSQL + ",GETDATE()"
>
>do I have to convert it with some FoxPro funtion to insert the current day into SQL table?