-
Notifications
You must be signed in to change notification settings - Fork 1
Date and time functions
Example: DATE(2012, 2, 2)
Returns the day of month from the supplied date
Example: DAY(DATE(2012, 4, 2))
Example: HOUR(Time(12, 13, 14)
Example(time as serialnumber): MINUTE(Time(12, 13, 14))
Example(time as string): MINUTE('10:12:14')
Example: MONTH(Date(2012, 4, 2))
Example: NOW()
Returns the second from a timestamp. The time can be a serial number from the TIME function or a string.
Example (time as serialnumber): SECOND(Time(12, 13, 59))
Example (time as string): SECOND('10:12:14')
Example: TIME(12, 13, 14)
Returns the date of today Example: TODAY()
Returns an integer representation of the weekday of the supplied date. The second argument is an integer between 1 and 3 that controls how the weekdays are represented.
1 - Sunday = 1... Saturday = 7
2 - Monday = 1... Sunday = 7
3 - Monday = 0... Sunday = 6
Example: WEEKDAY(TODAY(), 2)
Example: YEAR(NOW())