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.