Date and Time Functions

Excel Function 1010data Function Description
NOW() @now_ Returns the current date and time.
HOUR(serial_number) hour(X) Returns the hour portion of a time-related value.
MINUTE(serial_number) minute(X) Returns the minutes portion of a time-related value.
SECOND(serial_number) second(X) Returns the seconds portion of a time-related value.
DAY(serial_number) day(X) Returns the day portion of a date-related value.
MONTH(serial_number) month(X) Returns the month portion of a date-related value.
YEAR(serial_number) year(X) Returns the year portion of a date-related value.
WEEKDAY(serial_number,[return_type]) dayofwk(X) Returns the integer value corresponding to the day of the week of a date-related value.
DAYS(start_date,end_date) days(X;Y) Returns the number of days between two date-related values.