datetime local incompatable

AppSheet AppSheet Q&A
,
1

So i have my spreadsheet set as locale AUstralia

I can confirm this setting in the table settings of AppSheet, however I am getting nonsense datetimes from setting the initial value to

=DATETIME(TIMENOW())

resulting in this:

30/12/1899 07:14:00

Help, this is spinning my head!

1 Like
2

It is not clear what you are trying to do and achieve with the said expression.

TIMENOW() returns just a time value. But when you are type casting it to DATETIME type value, it adds a default date of 30/12/1899

Instead you may want to try just NOW()

3

If I remember, 30/12/1899 is equal to 0.

1 Like