>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 )
Bob,
You said 'definitely' but recheck. There si date and datetime which are both 8 in length (you can't change that). Also try :
if !eof()
REPLACE dsjn.req_date WITH date() in 'dsjn'
endif
PS: If you're at eof() no replace occurs.
Cetin