To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80371 Issue #|80371 Summary|dates offset by 2 days on import from Calc to Base Component|Database access Version|OOo 2.2.1 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|dreadnought1906
------- Additional comments from [EMAIL PROTECTED] Mon Aug 6 02:46:06 +0000 2007 ------- When dates are imported from a Calc spreadsheet to a Base database table, the date is changed by two days following the import. So, if one has a Calc table that includes the date 1991-01-01, the Base table, following import, will have the date 1991-01-03. No error is displayed. The method of import that produces this error is: 1. select data in spreadsheet, including column headers 2. copy using ctrl+c 3. go to 'Tables' section of Base database interface 4. paste using ctrl+v 5. select -either- the option to create a new table OR the option to append data to an existing table (both options produce the error) 6. if creating a new table, explicitly declare the column of dates to be a 'date' data type; if appending data, append column of dates to a field that is already a 'date' data type ------------ I hope this description is sufficient to help you track down this problem. If you want further details, please don't hesitate to ask. I would provide example files, but I can't seem to find a file upload option. I can, however, email them anywhere you might ask me to. Thanks so much, developers, you do a fantastic job! --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
