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)
>
>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.
--sb--