That's exactly what I needed!!! Thanks! I still haven't gotten used to that little question mark guy.
Laurisa
>The easiest way to do it is to assign the datetime value to a vfp variable, then use the ? to tell VFP to evaluate the variable and send its contents to the ODBC driver. Like this:
>
>m.ltDateTime={08/08/1998 10:00 AM}
>ntest=sqlexec(nconnect, "insert into pmwrkord ;
> (pmwrkord_code, its_current_date) ;
> values (9200007),?m.ltDateTime)")