>This is a date used in a MAPICS app on our iSeries. This is part of the Y2K fix.
>
>The 1 means 21 century or something like that.
>07 Year
>07 Month
>01 Day
Try CAST('20' + SUBSTRING(DateFiled,2,6) as Datetime) as ActualDate or the same with CONVERT function.
If it works, then just use DATEADD function.
If it's not broken, fix it until it is.
My Blog