>I simply want to put the system date in a field in a table.
>The field IS DEFINETLY set up as a date data type.
>However, the table designer will not allow more than 8 characters for this type of field.
>I use:
> REPLACE dsjn.req_date WITH date()
>The code kicks back with a 'data type mismatch' error.
The code is correct. The error says that "dsjn.req_date" must not be date format.
Are you sure you set it correctly? Does
"? VARTYPE(req_date)
" return a "D"?
>I've tried 'SET CENTURY OFF' no, avail...any suggestions?
SET CENTURY has to do with display not with internal date representation.
HTH