I am not sure what is happening now, ive used this for a long time and when I test the simple formula I get the correct time
But when I run the automation it writes the wrong time to the table
which is 6:42 pm and 7 hours off. Any idea why it is off when it writes to the table?
BTW, DATETIME(NOW()) is redundant; just NOW() is sufficient.
first thing i checked. im just not sure why its 7 hours off
Unfortunately, it’s then time to contact AppSheet Support for help with this.
So I tried something and got the same result. Instead of a bot to set the date time I made the default value for the field to datetime(now()) and it doing the same thing, off by 7 hours. Is there a locale for the entire program maybe?
Nope.
Is your data source locale and/or time zone set correctly?
How do I check that? I have seen on the bots the time zone setting but not for the app itself.
Maybe you have to define the location if its in a webhook. Eg. “Locale”: “nb-NO” (is for Norway)
See also here. https://support.google.com/appsheet/answer/10106702?hl=en&ref_topic=10102125&sjid=673024607828858213-EU
I checked the locale of the google sheet im using and it is set correctly. I changed the field default value to now() and checked the formula and I got this which is the correct time and date
and so I imported some records from the csv I downloaded and the time stamp of now() give this value
Still 8 hours off. I am not sure what is happening since I have used this formula and setup for a long time now and never had a problem. My time zone is GMT-08:00 Pacific time which is what time we are off but I am not sure why testing it gives the right time but when it is imported it gives the wrong time
I have no other suggestions so I’m afraid I have to refer you to AppSheet Support for further help with this.
Attn @AleksiAlkio
When you are importing data and the csv file doesn’t have any timestamp recorded, it writes the NOW() from the initial value as per UTC+0. That’s why there is 8 hours diffference.
@lizlynch , could you please update the CSV import docs to include how date and times are interpreted, per Aleksi’s comment above?
I’ve updated the documentation to indicate this.
When importing a CSV file, if the timezone is not specified then UTC+0 is used.
See also the note about the client timezone offset here:
https://support.google.com/appsheet/answer/10107326#date-time-expressions
Hope this helps!
