>>I am tring to do the impossible I think.
>>
>>I need to pull data from a remote data source. One of the fields is a date field with the format 1070701(July 1, 2007). I want to add another calculated field showing a date(normal format) that is this date plus 3 years.
>>
>>Any possibility this can be done?
>
>How 1070701 translates into July 1, 2007?

Would CAST('20' + SUBSTRING(DateFiled,2,6) as Datetime) as ActualDate work? I don't have SQL Server here to test right now.

If it works, then just use DATEADD function.