Hi, I had a problem with date values using the table copy wizard with the internal database.
Scenario: The table I wanted to copy to the database was in HTML orignally. It had a field with date values fomatted as dd.mm.yy. I opened it with writer, marked the table and copied it. In base I chose 'insert contents' and selected HTML as source format in the wizard. I created a new table with adding a primary key. I changed the column type of the date field to 'DATE'. All values were inserted correctly into the new table except the date values. They had all been converted two days forward. 30.04.05 became 02.05.2005 and so on. I tried some other scenarios: - copy the table to calc and select RTF asl Table source format - set the display format in calc to dd.mm.yyyy - leave the date column type as text, then copy the database table again and then set the column type to DATE for the second new table. The result was the same. I tried also to copy the values as text first and then change the column type in the table definition to DATE. This was rejected because the input format was now incorrect. At last I had to convert the date values in HTML to SQL format yyyy-mm-dd with an external script, what worked. (By the way: The 'Replace with' field of the Search and Replace dialog doesn't seem to support regular expression backreferences like '\1'). Is there a different interpretation of numeric date values in HSQLDB and the rest of OpenOffice.org? This happened on Windows XP SP2 using OpenOffice.org 1.95 with german language pack. Regards Michael -- Michael Mahrt Bergenring 44 D - 24109 Kiel Tel.: +49 431-6707360 Fax.: +49 431-6707361 Mobil: +49 163-4282040 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
