hi all,
i need your help to change ex..
my field have date as ("01/14/2000") and 02/18/2000 etc..

i need to change year 2000 to 2006 i try as under but not work

USE table1
**field name is dat the type is date
SET FILTER TO YEAR(dat)=2000
SCAN
replace YEAR(dat) WITH YEAR(DATE())
ENDSCAN
brow

thanks