Issue 89532 - Date field YYYYMMDD fails.
Summary: Date field YYYYMMDD fails.
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.0
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2008-05-15 22:50 UTC by villeroy
Modified: 2017-05-20 10:47 UTC (History)
1 user (show)

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

Database with a form (19.33 KB, application/vnd.sun.xml.base)
2008-05-15 22:52 UTC, villeroy
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description villeroy 2008-05-15 22:50:40 UTC
See attached file with 1 form and 3 records.
Comment 1 villeroy 2008-05-15 22:52:57 UTC
Created attachment 53682 [details]
Database with a form
Comment 2 drewjensen.inbox 2008-05-16 16:56:29 UTC
tested using OOo 2.4, XP

Using a custom date format of "YYYMMDD" will display existing records 
correctly, editing a date however writes an erroneous date to the attached 
column in the table.  (Note - I noticed that the database appeared to be setup 
of a German local so I tried the custom formatting string JJJJMMTT also, but it 
made no difference )
Comment 3 Frank Schönheit 2008-06-16 22:16:32 UTC
assigning, targeting
Comment 4 Frank Schönheit 2008-09-18 14:10:42 UTC
We use the number formatter's "IsNumberFormat( String, FormatKey, double& )"
here. As format key, we pass the key of the YYYYMMDD format, as string, we pass
something like "20080918". Unfortunately, the number formatter is "intelligent"
enough to recognize the string as numeric value, so the returned value in fact
is 20080918 as *number*, which we then force back to be a date, which results in

What we would need is a mode (or extra method) at the number formatter which
tells it to *first* examine the given string with respect to the given format,
and *then* attempt to interpret it as something else. (Currently, obviously the
string is *first* examined for being a mere number, and *then* the format key is
used to interpret it).
Comment 5 Marcus 2017-05-20 10:47:40 UTC
Reset assigne to the default "".