Unconsistent date formats


Have a look a this:

Although the 3 dates are the same, they seem to be stored differently.

And this is how it’s stored in Google Sheet:

And this is the locale:

Why is that?

Aren’t you using a date component for the DueDate and an Event Picker for the From & Up to? Isn’t it expected behavior or am I missing something here?

The date is:

October, 5th 2020

for all three dates.

In the first line, we have: 10/05/2020
But the next two lines: 05/10/2020

Not right, I think.

Ah apologies, I looked at your sheet screenshot and didn’t see the problem. Probably a displaying bug @Mark can help with.

Have a nice day yourself.