Mahmood,
Look at ctot() and ttoc() functions. To change the current record's year to 2002 (assuming you have date set to American):
set century on
replace timeField1 with ctot(stuff(ttoc(timeField1),7,4,"2002"))
>Hi All:
> I have a datetime field and I want to change the year to 2002. How can I accomplish this?
> I.E. 05/25/2001 5:25:23P.M. needs to be 05/25/2002 5:25:23 P.M.
>Thanks
Steve Gibson