Re: [libreoffice-users] User defined date field in Base not enforcing format

Le 2010-10-23 09:53, AG a écrit :
> Hey all
>
> Question about Base.
>
> In table I defined a field "date" to take year only (I don't want days 
> or months) for article publications.  I selected user defined in the 
> field properties and stipulated YYYY.  The example shows up as 1903 
> and the format field shows 1900.
>
> Now into the user form input, I enter 1991 into the date field and tab 
> to the next field and the date converts into today's date with the 
> format 23/10/10.
>
> How do I stop Base doing what it wants to do and make it to do what I 
> want it to do?
>
> Thanks
>
> AG
As far as I know, there are only two work arounds.
1. Enter the date as 1991-01-01 (or in whatever form your system wants 
it by default) and the date will be entered correctly.
2, Convert the field into a NUMBER field and format it as ####. After 
all, you won't calculate intervals.

--
Michel Gagnon
Montréal (Québec, Canada) -- http://mgagnon.net

--
E-mail to users+help@libreoffice.org for instructions on how to unsubscribe
List archives are available at http://www.libreoffice.org/lists/users/
All messages you send to this list will be publicly archived and cannot be deleted