Re: [libreoffice-users] Base date entry less flexible

On 12/29/2012 03:28 PM, Girvin R. Herr wrote:
> Greetings,
> I noted that after I updated LO from 3.5.7 to 3.6.4, the Base date 
> entry format flexibility has changed.  With a 3.5.7 (and before) Base 
> form, I could enter 12-29-12 and it would be changed to 12/29/12.  
> With 3.6.4, entering 12-29-12 will result in a strange date, as if it 
> were interpreting the dashes as a formula and maybe subtracting the 
> numbers.  Okay, I could live with that because it was apparent that 
> the date was incorrect.  But now I see this is resulting in a Java 
> error when I accidentally use dashes and try to save the record.  I 
> get "Java.lang.IllegalArgumentException" errors.  Even that could be 
> worked around, if the error message had any diagnostics, such as the 
> offending date.  However, this is all I get.  No SQL.  No indication 
> as to what the problem really is.  I got a clue by doing a web search 
> and found a similar error with dates and put two-and-two together to 
> determine the real cause.  I guess my complaint is that between 3.5 
> and 3.6, the error messages stopped putting diagnostic data into the 
> message. Has anyone else seen this "feature"?
> Is there an option somewhere to add the diagnostics to error messages?
>
> Note that I tried entering 12-29-12 into a Calc date cell where the 
> format was "MM/DD/YY" and it kept the dashes.
> Girvin Herr
     If you are going to use a date format with hyphens, perhaps 
learning to use this format: YYYY-MM-DD. This is recognized by both Base 
and Calc. (Probably by most databases and spreadsheets.

--Dan

--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted