>Hi
>I type "replace all datepaid with 04/05/2000 for group_code = "A01"
>It returns a error message data type mismatch.
>any help.
>John
Though the answer the others gave you works, you could run into problems if your STRICTDATE setting changes. If you create your date constant like this {^2000/04/05}, you won't have any problems with STRICTDATE. That's {^yyyy/mm/dd}.