Master,
thank you so much,it works:)
>
>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.