Hi, Henry.

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

Use the date() function. This is the best way to express a date value without having to worry about SET DATE settings.

mDayOfService   = val( SUBSTR(ConvertThis.LineItem,53,2) )
mMonthOfService = val( SUBSTR(ConvertThis.LineItem,56,2) )
mYearOfService  = val( SUBSTR(ConvertThis.LineItem,59,1) )

* Assuming the 1 digit year is from this century
m.ServiceDate = date( 2000 + mYearOfService, mMonthOfService, mYearOfService )

Hope this helps,