Apache OpenOffice (AOO) Bugzilla – Issue 8801
Dates read from .dbf file off by 3 days
Last modified: 2006-05-31 14:29:06 UTC
I have a simple database in .dbf/dBASE format for my accounts and invoicing system. The invoice is printed by OOo 1.0.1. The invoice date in OOo is displayed/printed 3 days _AFTER_ the date in the .dbf file, i.e. 29 June 2002 prints as 1 July 2002. The data source is sdbc:dbase. I'm in the UK and use English (UK) as the locale, although I doubt that this affects the problem. Philip
Philip, thanks for supporting OOo and for filing this. Do I understand you correctly that you use form letter fields which are bound to a date field in the database? Additionally, if you did not mistype the dates, the difference is 2 days, not three days, isn't it? Thanks, Frank
Hi Frank, Sorry, I should have been more complete in my report. Yes, I created the invoice template using Writer and embedded form fields from the database in this document. Re 2 vs 3 day offset - depends if you count the date in the database as day 1 or day 0. Programmatically I agree with you that it should probably be day 0 (i.e. 2 days off). Also the .dbf is in DOS/ISO850 format. HTH Philip
Philip, thanks for the feedback. for the 2 days: between "29 June 2002" and "1 July 2002" are two days, no matter what the days of the respective date system is, aren't they? Assigning this to os@openoffice.org - Oliver, I think you fixed this recently in the form letter implementations .... Frank
Frank <quote>for the 2 days: between "29 June 2002" and "1 July 2002" are two days, no matter what the days of the respective date system is, aren't they?</quote> Not if you are my accountant <vbg> Philip
fixed in srx644h
Closed.
change subcomponent to 'none'