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.