@adhaputraa wrote:
I have some question about timezone on Appsheet. First of all, what's the different between datetime NOW() and TODAY() formulas?
NOW() results in the current date and time at the users locale. TODAY() only provides the current date as the users locale - technically the date + midnight (00:00:00). Note that there is also a UTCNOW() function that will return the same DateTime no matter what locale the user is in.
@adhaputraa wrote:
Also, I created an Automation for sending an emails to notify the user about approving the data with embedded app view and even when we're still in the same region and exactly the same time pressing approval button, the timezone formulas makes some difference about 4-5 hours. Is there any chance to setting the timezone on Appsheet?
I assume you are using the the "ChangeTimestamp" type column? It defaults to using the UTC DateTime. If that is the column type you are using and want to show that DateTime for your locale, you will need to include another column and apply the timezone conversion. You can do this like so:
adjusted datetime column -> [Change Date] - (UTCNOW() - NOW())
The alternative is to use your own Change DateTime column so the value is in the users locale but then you would need to manage when this date is updated based on changes. This could be just as easy as setting an App Formula to NOW(). But if you have special criteria such as only updating when certain columns change, the management is slightly more cumbersome.
LinkedIn
Twitter
