<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - date with custom format macro and locale other than English don't produce desired result"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=107012">bug 107012</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>RESOLVED
</td>
<td>NEW
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>WORKSFORME
</td>
<td>---
</td>
</tr>
<tr>
<td style="text-align:right;">Assignee</td>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
<td>erack@redhat.com
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - date with custom format macro and locale other than English don't produce desired result"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=107012#c5">Comment # 5</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - date with custom format macro and locale other than English don't produce desired result"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=107012">bug 107012</a>
from <span class="vcard"><a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</span></a>
</span></b>
<pre>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 <a href="show_bug.cgi?id=107012#c3">comment #3</a>)
<span class="quote">> 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,</span >
Yes.
<span class="quote">> and this will only work correctly,
> if you use the order of day, month and year which corresponds to the locale.</span >
Which is the bug here.
<span class="quote">> 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.</span >
? I get 04.13.2017 (i.e. separator adapted but the wrong order).</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>