REPLACE OtherField WITH STRTRAN(OtherField, [2000],[2006]) FOR [2000] $ OtherField

>hi,
>thank you for reply and for 29/02/,it works ,
>i have another table have charcter field as "March 2000" and "April 2000 ",
>
>is there a way to change 2000 to 2006
>
>thanks
>
>>>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
>>
>>

>>REPLACE Dat WITH DATE(2006,MONTH(Dat), DAY(Dat)) FOR YEAR(Dat) == 2000
>>

>>
>>BUT be careful if you have Date -> 02/29/2000 because 2006 is not a leap year.