Now() function

[Andy_strathmore]

I have an action adding info to log table.
There is a column saving create time(datetime),I use function now() to get current time.
Locale google sheet has been set to Aus and time zone as well.
However, while bots has been trigger, now() function return a American Time.

Am I make a mistake in setting?

[bonameblisto]

As Im understand, you logs textual value for logged record.
Try to use time() function

help.appsheet.com

TIME()

Time from Date, DateTime, or Time

[Andy_strathmore]

Day,month and year info are necessary.So I tried DATETIME(now()).
Still showing American time.
Even TIME(NOW()) is the same result.

[SkrOYC]

BTW, this are formulas inside the App or the spreadsheet?

[Andy_strathmore]

inside action in the app.

[bonameblisto]

Excuse me, pls!
On my previous post Im mistake function name. Not time(), but

help.appsheet.com

TEXT()

Format as text

Second param allows to set necessaryd format
(If we are speech about text field)

Which type is your “date” column?

[SkrOYC]

Andy_strathmore:

Locale google sheet

Have you changed the Localization info under Data → Tables → Your table?

[Andy_strathmore]

Yes, I checked.
After I change Locale in google sheet, Localization in Data has been changed automatically.

[Steve]

Andy_strathmore:

However, while bots has been trigger, now() function return a American Time.

Where are you seeing the American time? Can you post a screenshot?

[Andy_strathmore]

First Image is showing the log I got and second one is actual Eastern Time(GMT+10:00).