TIMENOW() function

[Kevin_Vandeness]

Hello everyone,

I have a little problem with my app. I’d like to show the exact time when I save my data. To do that :

• My column name is " Horodateur "
• Type is DateTime
• Initial value is TIMENOW()

But it doesn’t work. I got, as result, a date and a time and the worst is that the date begins at 30/12/1899.

Can you help me please ? I just want to indicate the exact time (HOUR:MINUTE) of the day.
Thank you in advance !

[Steve]

help.appsheet.com

NOW()

Current date & time

[Kevin_Vandeness]

Hello Steve,

Thank you for your answer. I have already read this page and tried the function TIMENOW() but it doesn’t work.

[hru]

You should use initial value of NOW()

[Bahbus]

TODAY() retunds a Date. TIMENOW() returns just a Time. NOW() returns a DateTime.

Your column is currently a DateTime which means it will contain a Date and a Time, hence DateTime. Make sure you use the appropriate column type in conjunction with the function you want.