Can you tell me about “timenow”, who make by server ?
TIMENOW(), and all other time & date query functions, uses the device’s local time, except when used in workflows. In workflows, it uses the AppSheet server’s time.
Can you show it to me the sampe ?
@Steve to clarify a bit further …
Thanks your solution
Hi @praveen!
When I travel, I sometimes keep my phone set to Japan time because I don’t want the times recorded to be affected by time zone changes. Perhaps if developers could choose to have times zone recorded in a column separate from the time stamps column it would become possible to really know when something happened and put the times in chronological order. Or, better yet, if we could choose to have a time stamp that appends the time zone, that might be even better. Then we could parse the data on our own. Just a thought; I don’t know if this would be difficult to implement or not.
Consider…
USERTZOFFSET()
UTCNOW()
(NOW() & " " & USERTZOFFSET())
Thanks that solution, i try first
Thanks from me too. I assumed that it wasn’t possible. “Assumptions” are a problem I never seem to fully overcome.
I posted about this issue in “Tips & Tricks”:
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |