https://bugs.documentfoundation.org/show_bug.cgi?id=150288
--- Comment #9 from Joao Carvalho <[email protected]> --- Let me first define three different Language settings that I tried: Language settings 1: User interface: Default - English (USA) Locale setting: Default - English (USA) Date acceptance patterns: M/D/Y;M/D Language settings 2: User interface: Default - English (USA) Locale setting: Default - English (USA) Date acceptance patterns: D/M/Y;D/M Language settings 3: User interface: Default - English (USA) Locale setting: Portuguese (Brazil) Date acceptance patterns: D/M/Y;D/M I am not 100% sure, but I think that I was using Language settings 2 when I first started this thread on Aug 6th. What I know for sure is this. If I change the Language settings to one of the the above, and then try the "Steps to Reproduce" that I initially wrote, I get the following results. Language settings 1 and 2: Typing 31/8/22 automatically formats to 31/08/2022, but typing 1/8/22 automatically formats to 08/01/2022. Aug. 1st becomes Jan. 8th. Language settings 3: Typing 31/8/22 automatically formats to 31/08/2022, and typing 1/8/22 automatically formats to 01/08/2022, as I expected. Please note that my individual problem is solved. All I have to do is use Language settings 3. What I think is really confusing and should be looked at is the fact that Language settings 1 and 2 produce conflicting results. If 1/8/22 was to be interpreted as Jan 8th, then 31/8/22 should not be recognized as a valid date. On the other hand, if 31/8/22 should be recognized as a valid date, then 1/8/22 should be interpreted as Aug 1st. -- You are receiving this mail because: You are the assignee for the bug.
