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
The subject mentioned sorting.by date. What’s the issue insofar?
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.