View Single Post
  #1   Report Post  
Ellen
 
Posts: n/a
Default date from query when brought into excel is incorrect

We are having an issue with Excel where a user who is using the web version
of Business Objects is doing a query. They then save the query as an Excel
document. The problem is that the date in excel is different than the query
results. The dates that are 01/01/1900 in Business Objects show as
01/02/1900 in Excel. The only date that doesn't change is 1/1/2005.

Is this a known issue? If it is, is there a fix for it? I found an article
on the differences between 1900 and 1904 dates in excel but it didn't seem to
address the same issue.

We are using Office XP (2002).