Ask Your Question

Problem sorting by date

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

MoHP gravatar image

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,


edit retag flag offensive close merge delete


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

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

1 Answer

Sort by » oldest newest most voted

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

erAck gravatar image

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 more
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 46 times

Last updated: Jan 15 '19