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

Hi :)
Sounds like a good fail-safe, so that users are not bound by rigid
restrictions but the displayed figures are always consistently correct.

I suspect that you can even enter much shorter numbers for dates within the
year, such as;
12.31
getting corrected to;
2014.12.31
I'm not sure if you can also drop the month, if it's within the same month,
and just type
31
to get the same result but even a little less typing can make a
difference.
Regards from
Tom :)




On 28 December 2014 at 04:43, Brian Barker <b.m.barker@btinternet.com>
wrote:

> At 02:29 28/12/2014 +0000, Conly Honly Donly wrote:
>
> > 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.
>
> I'm guessing here, but surely there are different requirements in the two
> places? In the cell formatting, you are indicating exactly the format you
> require - so you are choosing the year to appear as YYYY, not YY, for
> example. But the acceptance pattern is more general: you are merely showing
> that you want year-dot-month-dot-day to be a format automatically
> interpreted as a date. With Y.M.D as an acceptance pattern, can you not
> enter the forthcoming New Year's Day (for example) as 2015.01.01, 2015.1.1,
> 15.01.01, and many other forms - but have all interpreted correctly and
> displayed in the cell itself in the cell's format - as 2015.01.01 in your
> case?
>
> I trust this helps.
>
> Brian Barker
>
>
>
> --
> 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

-- 
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