<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Sorting in Calc by Date"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=138652#c7">Comment # 7</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Sorting in Calc by Date"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=138652">bug 138652</a>
from <span class="vcard"><a class="email" href="mailto:saltyla1@gmail.com" title="saltyla1@gmail.com">saltyla1@gmail.com</a>
</span></b>
<pre>I have found that in the Format Cells dialog window,
Numbers tab, Category "date" > Format , the first 12/31/99 , which
has a format code of M/D/YY is not a match for 12/31/99. It should be
single digit/single digit/double digit , as M/D/YY suggests(I.E. 9/2/99)
I have changed all of the input dates to match MM/DD/YY and it works
for both selections of 12/31/99 .
The second instance of 12/31/99 with format code MM/DD/YY is correct.</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>