Bug when we put a date in the glide sheet

Hello, I have a date problem, when for example I enter 11.07.2022 in the glide table, this one reverses it and it gives me the date of 7 November 2022 (7.11.2022) instead of keeping the July 11, 2022. This looks like a bug, does anyone have an idea?

It not a bug if you live in the U.S. :wink:

If you are going to enter dates like that, I suggest using year/month/day (2022.07.11) instead of day/month/year or month/day/year. Year/month/day is agnostic and recongized the same everywhere.