[libreoffice-users] Re: Base Date issue

Le 02/03/11 16:08, Leslie D. Martin a écrit :

Hi again Leslie,


> Interesting. I have the field masked as YYYY which I understood tells Base
> to expect and accept only a year number. If I put in a full date (ie,
> 01/01/1996) the year shows up correctly. This doesn't seem to be proper
> behaviour to me.

No it isn't, in the sense that the formatting you specified isn't
applied, but if you configured your database field as DATE, then in Base
that means whatever the locale representation string is, e.g.
"YYYY-MM-DD", so Base doesn't understand when you just type in the year.
This is why it works when you type in the whole date.

> This, of course, brings up two questions: 1) how do I make this work the way
> I need (having a field where the user simply puts in the 14-digit year); 

I have no answer to that one other than configuring your database field
as INT(4) and using an integer to represent the year as YYYY instead,
but this means that you get only that data in the database, and not the
whole date. I'm pretty certain that this problem has already come up on
the OpenOffice.org forums (but not necessarily their mailing lists).



2)
> how do we get this fixed in Base so that it works correctly without having
> to resort to the work-around requested in item 1 (see previous)?

I can't see this happening in LibO anytime soon, there is a noticeable
and rather worrying dearth of Base developers in the LibO developer's group.



Alex


-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***