datetime local incompatable

[chocbudda1]

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!

[Suvrutt_Gurjar · Accepted solution]

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()

[AleksiAlkio]

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