Is it string or number? Do you want to create new calculated field in the query itself or on VFP side?

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