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.
- Ravi
True greatness consists in being great in little things.
- Charles Simmons