DateTime cells hold Date with Time, a user can use a calendar and a time picker to set the date and time. Date and time will be the same for all users, no matter in what time zone user is located.
DateTime cells formulas have to return date object.
Formulas examples:
=NOW() - return current time
=TODAY() - returns today date and 00:00:00 time
=DATE(2000,1,1,1,1,1) - returns 1 of January year 2000, hour 01:01:01
0 Comments