Hi everyone, we have a problem in one of the apps, in change time stamp column it states date invalid but in google chrome it is ok we have the time stamp there, but the app cant read it, we have tried everything, and still states date invalid.
, but the v yccan not read it.
@ns_soft_studio1
The format in your gSheet shall be mm/dd/yyyy hh:mm:ss. Have you also checked the LOCALE setting of your table in the app?
yes of course, we have checked that, and what is more interesting it reads new inputs ok, but rest of them all invalid.
ns_soft_studio1:
reads new inputs ok, but rest of them all invalid.
So data created by the ChanteTimestamp column is valid, but anything that was already there isn’t?
What happens when you go into a record created by the ChangeTimestampe, and manually change it (say off by a day or something easy to put back); is it still valid?
we will try that right now, and get back to you.
here is the new input and it reads it ok… that we mentioned earlier.
we have tried and it reads it ok… it showed up in the app
sorry it didn’t show up that one we have changed was ok it was showing in the app already,
when we tried one that state date invalid it was still the same no mater how we have changed it.
Hmmm… curious. Perhaps just hit the whole column with a DateTime formatting in Gsheets again? Maybe the top half missed it.
still the same… some are there and a lot states date invalid same format and same rules, no coding attached, all of them was there two days a go, but now it just wont read it in the app.
thanks a lot by the way for trying to help we a are clueless crazy_face:
My guess is the invalid values are actually text values, not datetime values, or vice versa.
it is “change time stamp” column…
Sorry, I meant the values in the spreadsheet.
l the same
Hmmm… You can check the data in the column by creating a new column and using an = formula to pull in the data; then format the new column to plain text to see what’s actually there.
If it’s a datetime, you should end up with a decimal number.
Check out what happens when I change a datetime cell to Plain text:
tried, some stays as time date format some converts into decimal numbers… ???
Okay, Steve was right:
Steve:
invalid values are actually text values, not datetime values,
When you ran that check, the ones that stayed looking like a datetime are the ones with incorrect data. The reason you see the number when you do a check like I described, is because datetimes are stored in the spreadsheet as an actual decimal number (it’s something like, how long has it been since 1899 or something).
So when you change the data to text, it shows you the decimal that represents that datetime.
More here
You need to get all the data as actual datetimes.
Hmm… not sure the best/easiest way to do this. @Steve…
is there a way to do it…
If you click on one of these cells, in the formula bar do you see a little ’ ?
