Hi Tom,

You must use parametrized SQL command:
pdDate=IIF(EMPTY(_Field_),.NULL.,_Field_)
?SQLEXEC(nHand,"INSERT INTO _Table_ (_Field_) VALUES (pdDate)")

or use "Date, Time, and Timestamp Escape Sequences"
if date is not .NULL.:

* YYYY-MM-DD
lcDate=DTOS(_Field_)
lcDate=LEFT(pcDate,4)+"-"+SUBS(lcDate,5,2)+"-"+RIGHT(lcDate,2)

lcSQL="INSERT INTO _Table_ (_Field_) VALUES ({d '"+lcDate+"'})"

?SQLEXEC(nHand,lcSQL)

Martin