Timestamp wrong


I have a new app with different tables, all of them have a TIMESTAMP question set for NOW.

All of them except for one give me the Dec 30, 1899 timestamp as NOW. That was the case on Androids, IOS and the browser.

Any ideas? See attached…

Thank you!

You have a DateTime column, not a Time column. So the date is defaulted.

1 Like

Wait, I’m backwards, and misread. The word timestamp threw me off.

NOW should return the DateTime
TIMENOW should return Time
TODAY should return Date

You have these all setup as DateTime with NOW()?


Thanks @Bahbus

I had understood you, I changed it and it works. Any idea why appsheet might have automatically created those formulas differently if they were al the same type?