Issue 22687 - Dates are shifted of 2 days in dbf tables in DataSource
Summary: Dates are shifted of 2 days in dbf tables in DataSource
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC4
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-11-20 20:33 UTC by Unknown
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Unknown 2003-11-20 20:33:03 UTC 
bugs in version 1.1rc4 for Windows (with Win XP pro, not Linux RH9):

In a "Datasource" dbf table with 1000 records
with this structure:

DATAESAME,D	(date)
COGNOME,C,30	(char)
NOME,C,30	
DATANASCIT,D	
INDIRIZZO,C,50	
CITTA,C,30	
TELEFONO,C,30	
PRESTAZION,C,50	
PROVENIENZ,C,30	
MEDICO,C,50	
REFERTO,M	(memo)

I found another bug in updating OpenOffice from version 1.0.3 to
1.1rc4 with the Windows version:

All dates in the dbf table (produced with the previous versions of OO) 
are shifted of 2 days (huge bug!). Your date routines need to be
reviewed to be more reliable.

Check also the date format.
I am trying to use OpenOffice as a small RIS (radiology information
system) for the patients RX reports and for storing records.
Comment 1 marc.neumann 2003-11-24 08:15:49 UTC 
Hi liscia,

Can you please attach such a dbf file. 
I can't reproduce it when I create a new dbf table via OOo 1.0.

In OOo 1.1 and OOo 1.0 both dates are the same.

Bye Marc
Comment 2 marc.neumann 2004-01-05 11:59:20 UTC 
hi all,

no more info since 4 weeks.
I close this issue as works for me. Please fell free to reopen this issue if it
still occurr. If you reopen this issue please provide a step-by-step description
how I can reproduce this issue.

bye Marc
Comment 3 marc.neumann 2004-01-05 12:00:05 UTC 
closed
Comment 4 marc.neumann 2004-01-05 12:01:02 UTC 
remove keyword
Comment 5 hans_werner67 2004-02-02 12:28:48 UTC 
change subcomponent to 'none'
Comment 6 Frank Schönheit 2004-05-06 09:37:07 UTC 
note: I just submitted issue 28807, which may describe the same problem as this
one here.