Issue 50488 - confusing reordering of day, month and year after entering a date into a date field in OOo Base
Summary: confusing reordering of day, month and year after entering a date into a date...
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.0 Beta
Hardware: Other Windows XP
: P3 Trivial (vote)
Target Milestone: OOo 2.0.1
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2005-06-08 14:50 UTC by psy96
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

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

Attachments
database sample for issue#50488 (19.05 KB, application/vnd.sun.xml.base)
2005-06-09 10:23 UTC, psy96 		no flags Details
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 psy96 2005-06-08 14:50:06 UTC 
After entering 

11.04.2005

into a date field in OOo Base, the program modifies the date to 

04.11.05 00:00

Confusingly, this is not just replacing the month with the day and vice versa, 
because entering

04.11.2005

yields the date

04.11.05 00:00

as well.
Comment 1 marc.neumann 2005-06-09 08:11:42 UTC 
reduce prio to 3
Comment 2 marc.neumann 2005-06-09 09:15:51 UTC 
Hi,

I can't reproduce it.

- What database do you use? (hsql, dbase, mysql, jdbc, odbc, ...)
- What locale do you use? ( en_US, de, fr, .... )
- What languages do you use under TOOLS / OPTIONS / LANGUAGES / LANGUAGES ?
- Do you have a sample database which you can attach?
- Any other information which can help ?

Bye Marc
Comment 3 marc.neumann 2005-06-09 09:16:10 UTC 
add keyword
Comment 4 psy96 2005-06-09 10:13:15 UTC 
database type: 
Microsoft Access

locale: 
I guess en_US (is there any other local in 1.9.104?)

language settings (TOOLS / OPTIONS / LANGUAGES / LANGUAGES): 
user interace = default; locale setting = default; decimal separator key = same 
as default(,); default language for documents = English (USA)

field format:
right-clicking on the date column and selecting 'column format' yields the 
following information:

Category = Date; Format = 31.12.99 13:37; Language = German(Germany); Format 
Code = TT.MM.JJ HH:MM
Comment 5 psy96 2005-06-09 10:23:47 UTC 
Created attachment 27042 [details]
database sample for issue#50488
Comment 6 marc.neumann 2005-08-18 13:58:30 UTC 
HI,

I can reproduce this with the attached sample database. Thanks for attaching
this easy sample.

reassign to the right developer and set target.

Bye Marc
Comment 7 ocke.janssen 2005-08-19 07:54:57 UTC 
Fixed in cws dba201c.
Comment 8 ocke.janssen 2005-10-12 07:40:42 UTC 
Please verify. Thanks.

re-open issue and reassign to msc@openoffice.org
Comment 9 ocke.janssen 2005-10-12 08:23:14 UTC 
.
Comment 10 marc.neumann 2005-10-13 13:52:20 UTC 
set to fixed
Comment 11 marc.neumann 2005-10-20 08:51:20 UTC 
verified in cws dba201d
Comment 12 marc.neumann 2005-12-20 10:22:05 UTC 
Hi,

this is fixed in the current master. The current master is available at
http://download.openoffice.org/680/index.html

I close this issue now.

Bye Marc