Robert,
What happens if you:
REPLACE req_date WITH date() in dsjn
or
select dsjn
replace req_date with date()
>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 )
Steve Gibson