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
>
>