Baseline1 estimated finish - export to excel - data disconnect. - MSProject 2010 SP1
Greetings and Happy Monday!
We are finding some disconnect on the data in the field 'BaselineX Estimated Finish' - after saving the project in an excel file. It seems, some of the date values in 'BaselineX estimated finish' after exporting into excel are showing a different date value.
For example, in the MSProject file, the 'Baseline1 Estimated Finish' date for one of the task = May 31 2013. Where as the same task's field value shows June 4 2013 - after exporting the file into an excel format.
Unfortunately, the similar field value 'BaselineX Finish' (without the 'ESTIMATED' tag) - although exporting with the correct value - does not help. The format in 'BaselineX Finish' field value includes a time stamp - which could not be reported through a pivot of excel.
Any advise would be very helpful!
Thank you again!
|