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

Thank you Martin. The above works, but is based on the assumption that the 1 digit year is from this century.

Downside, it could be anywhere say for the last 30 years. Would the "Modified" column in Windows Explorer be useful in telling us of the exact year? If so, how doI capture that information?

Thank you again.