conversion

rajee1234 · Post by **rajee1234** » Thu Sep 17, 2009 4:01 am

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

ArndW · Post by **ArndW** » Thu Sep 17, 2009 4:09 am

Assuming you are keeping string format:

Code: Select all

IF In.DateString < 10 THEN '20':In.DateString ELSE '19':In.String

This assume the year 10 as the century break year.

chulett · Post by **chulett** » Thu Sep 17, 2009 5:19 am

Otherwise just add 2000 or 1900 for a numeric solution.