Hi Henry,

One digit isn't enough to make relaible conversion because '2' could mean 1992, 2002, 2012 and so on.

>Hi All:
>
>I extract the data from a sdf file and populate a table and then process as follows:
>
>

mDayOfService = SUBSTR(ConvertThis.LineItem,53,2)
>mMonthOfService = SUBSTR(ConvertThis.LineItem,56,2)
>mYearOfService = SUBSTR(ConvertThis.LineItem,59,1) &&the document only provides 1 digit for the year

>
>How do I take the above information and convert it to read, say MM/DD/YYYY? Specially when only 1 digit of the year is available to me from teh source document.
>
>Thank you for your advise.