>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 )
Probably you will want to change the field type to "D" (date). You can't store date() (type date) into a character field without conversion. And I don't recommend, usually, using anything other than date type for date fields.
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)