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๐
Check your date format in Excel and the column type so it matches with the app
Hello kind as always, I checked the dates in excel they are formatted in date
What dates are working properly from your printscreen?
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
Is the column type properly set for all of these invalid rows in your Excel?
right
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๐
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
HI
thank you for your help for anyone who encounters a problem similar to mine, I solved it like this
So.. your locale setting was wrongly set in the table's definitions?
Exactly, I don't know if it depends on the company PCs that are set in English, I don't know, I think
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |