I may be missing the point entirely but how about

lcSQL = 'UPDATE ' + cMyTable + ' SET ' + cMyDateField + ' = dSomeDate '   + 'WHERE ' + MyKeyField + ' = ' + uKeyField

>Hi All,
>
>I'm buiding an SQL string to execute as a macro or an EVALUATE(). Every data type I've tested thus far works except for DATE.
>
>lcSQL = 'UPDATE ' + cMyTable + ' SET ' + cMyDateField + ' = ' + dSomeDate + 'WHERE ' + MyKeyField + ' = ' + uKeyField
>
>&lcSQL
>
>Converting dSomeDate to a Character causes a data mismatch error.
>
>Any ideas on how to accomplish this?
>
>TIA
>Robert
>
>