https://bugs.documentfoundation.org/show_bug.cgi?id=107012
--- Comment #3 from Gerhard Weydt <gerhard.we...@t-online.de> ---
If I understand Eike's answer correctly, then the slash in the second parameter
of FORMAT doesn't mean the character "slash", but represents the separator
between day, month and year, which is changed to the local separator according
to the locale used, and this will only work correctly, if you use the order of
day, month and year which corresponds to the locale.
Indeed, Format(Now(), "DD/MM/YYYY") yields 13.04.2017 with german locale,
whereas Format(Now(), "MM/DD/YYYY") yields 04/13/2017, with correct numbers,
but another separator.
In my tests I found out that you often can use period or hyphen as separator,
as well, but this does not work in all cases.
So the recomendation wold be to use the correct separator *and* the correct
sequence fitting your locale for the format in accordance with the local, or
quote the character you wish to force withe backslash.
If the separator used is not connected with the date acceptance pattern, it
must be defined within the locale. And it will normally coincide with the first
date acceptance pattern for a locale, so it's no wonder I didn't find a case
contradicting my hypothesis.
I will propose an addition to the help text in a new bugzilla entry.
@Adrian: I think your bug can be regarded as resolved, but I leave it to you to
change the status accordingly.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
