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.

I've tried 'SET CENTURY OFF' no, avail...any suggestions?

Thanks in advance!
Bob Ross ( A confused newbie )