DSXchange

Hi,

I have source like.... Its an year in the format (yy)

86,78,98,04,01,05....

i need to convert this source into (yyyy) format... target as..

1986,1976,1998,2004,2001,2005....

Thanks in advance

Assuming you are keeping string format: This assume the year 10 as the century break year.

Otherwise just add 2000 or 1900 for a numeric solution.