Re: [libreoffice-users] Dot separated date in YYYY.MM.DD format

 Hello all,

Thanks for following up.

A quick recap: I was looking for the YYYY.MM.DD format. The user inputs it as it looks, e.g. 
2015.01.01. (LibreOffice Calc should recognise it as a date.)

Here:

Tools -> Options -> Language Settings -> Languages -> Date acceptance patterns

I don't know how this should be set.

I tried YYYY.MM.DD. This did not work.
(with the semicolon)

I tried Y.M.D. This worked.
(with the semicolon)

Here:

Format -> Cells -> Numbers -> Format code

I must use YYYY.MM.DD, not Y.M.D.

What led to this inconsistent format? I am interested in the technical reasons behind.

I think that it will be consistent if a user is allowed to type the same YYYY.MM.DD format code in 
both places to get what she or he wants.

Best wishes,
C. H. D.


_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 

-- 
To unsubscribe e-mail to: users+unsubscribe@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