ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   date from query when brought into excel is incorrect (https://www.excelbanter.com/excel-discussion-misc-queries/17099-date-query-when-brought-into-excel-incorrect.html)

Ellen

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).





All times are GMT +1. The time now is 03:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com