[Libreoffice-bugs] [Bug 107012] date with custom format macro and locale other than English don' t produce desired result

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=107012

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |NEW
         Resolution|WORKSFORME                  |---
           Assignee|libreoffice-bugs at lists.free |erack at redhat.com
                   |desktop.org                 |

--- Comment #5 from Eike Rathke <erack at redhat.com> ---
This is not resolved though, I'm keeping the bug for the wrong date order if
the actual locale one's is different from MDY (which it usually is). Bear in
mind that the BASIC locale is en-US and formats are converted to the output
locale.

As a side note, if you want locale independent date formatting use the ISO
sequence YYYY-MM-DD

(In reply to Gerhard Weydt from comment #3)
> 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,
Yes.

> and this will only work correctly,
> if you use the order of day, month and year which corresponds to the locale.
Which is the bug here.

> 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.
? I get 04.13.2017 (i.e. separator adapted but the wrong order).

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170418/f41fb33a/attachment.html>