Problem sorting by date

asked 2019-01-15 18:53:48 +0100

MoHP
1 ●1

One post mentioned to change the Date Acceptance Patterns on Language settings to the type of format I used on the sheet MM/DD/YY but it keeps going back to the previous setting M/D/Y;M/D

Thank you,

MHP

edit retag flag offensive close merge delete

Comments

The subject mentioned sorting.by date. What's the issue insofar?

Lupp ( 2019-01-15 23:14:44 +0100 )edit

add a comment

1 Answer

Sort by » oldest newest most voted

answered 2019-01-15 19:22:52 +0100

erAck

3403 ●26 ●44 https://erack.de/

Date Acceptance Patterns consist only of single occurrences of the letters Y, M or D. If you tried to literally enter MM/DD/YY then the input is not accepted. Anyhow, date acceptance patterns describe the order and separators accepted for date input, not an exact format, the existing M/D/Y there already covers your MM/DD/YY case.

edit flag offensive delete link

add a comment

Question Tools

1 follower

Stats

Asked: 2019-01-15 18:53:48 +0100

Seen: 26 times

Last updated: Jan 15

Problem sorting by date edit

Comments

1 Answer

Question Tools

Stats

Related questions

Problem sorting by date