https://bugs.documentfoundation.org/show_bug.cgi?id=173670
--- Comment #8 from Jonny Grant <[email protected]> --- (In reply to LeroyG from comment #6) > (In reply to Jonny Grant from comment #0) > > Cell A1 is formatted ISO 8601 YYYY-MM-DD > > > > 1. Type: 20 Jan <enter> > > 2. Observe it shows 2020-01-01 > > Expected: 20 Jan 2026 > > If do you expect "2026-01-20" type "Jan 20". Otherwise, set the cell > formatting to "DD MMM YYYY". > The acceptance pattern will follow the cell formatting. > > Not a bug for me. Your description of the workaround is accurate, it is what is used at present as a workaround in Calc. American's write "20 Jan" meaning the same as "January, 20th". They don't mean "1st January 2020". ISO format dates also follow international conventions, where 20th means the day of the month. Calc should reflect common usage. -- You are receiving this mail because: You are the assignee for the bug.
