>>
>>

cSqlInsert = "insert into Company (	MYDATEFLD ) values " + ;
>>	"(" + IIF(lfdate="NULL",[NULL],[']+lfdate+[']) + ")"

>
>Fred,
>
>This is kind of sort of what I did, your code is obviously more elegant <g>. Thank you very much.

Actually, if your field in SQL is a datetime type field, I'd do it this way:

lfdate = NULL   && note no quotation marks!
cSqlInsert = "insert into Company (	MYDATEFLD ) values " + ;
	"(?lfdate)"

This should work if the lfdate contains a NULL value or a date value.