Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I enter a date before 1900 in excel? | Excel Worksheet Functions | |||
Help with Charting My Data -- | Charts and Charting in Excel | |||
Auto date changing in Excel is maddening | Charts and Charting in Excel | |||
New web query with Excel Pro Edition 2003 | Links and Linking in Excel | |||
Creating a Date Selector in Excel VBA? | Excel Discussion (Misc queries) |