Invalid Date

[Cannone_Cannone]

Good morning everyone
I have this small problem with the dates, in an online Excel sheet I pasted the dates manually, in the application in a "Table" view on some dates it gives me an "Invalid Date" error, but if I open the view to modify the field I correct, I don't understand!

Thank you😗

[AleksiAlkio]

Check your date format in Excel and the column type so it matches with the app

[Cannone_Cannone]

Hello kind as always, I checked the dates in excel they are formatted in date

[AleksiAlkio]

What dates are working properly from your printscreen?

[Cannone_Cannone]

For example,

Training Date  : 24/07/2019 ok

Expiring Date : 23/07/2024 Invalid date

Training Date  : 24/07/2019 ok

Expiring Date : 31/08/2021 - 30/08/2026 invalid date

[AleksiAlkio]

Is the column type properly set for all of these invalid rows in your Excel?

[Cannone_Cannone]

right

[Cannone_Cannone]

Hi, in the sheet I ordered them one way, if I go to view data it puts them backwards, but only I have all these problems😂

[Cannone_Cannone]

Hi, I'll update you, I tried to transform the two columns in Appsheet into text format, this way it displays them all, but I can't keep them like this

[Cannone_Cannone]

HI
thank you for your help for anyone who encounters a problem similar to mine, I solved it like this

[AleksiAlkio]

So.. your locale setting was wrongly set in the table's definitions?

[Cannone_Cannone]

Exactly, I don't know if it depends on the company PCs that are set in English, I don't know, I think