Time Expression :
NOW
The current date and time are returned using the NOW function.
Syntax
NOW()
Example
NOW() : Current Date and Time
(NOW() - 1) gives the date & time one day in the past.
(NOW() + 1) gives the date & time one day in the future.
(NOW() + 7) gives the date & time one week in the future.
DATE(NOW()) gives the current date as a Date value.
TIME(NOW()) gives the current time.
Return Value
This function returns a DateTime value that gives the current date and time.
Learn more about NOW
TODAY
The current date is returned by the TODAY function.
Syntax
TODAY()
Example
TODAY() : Current Date
(TODAY() - 1) gives yesterday's date.
(TODAY() + 1) gives tomorrow's date.
(TODAY() + 7) gives the date one week from today.
(TODAY() - WEEKDAY(TODAY())) gives the date of Saturday of last week.
(TODAY() - WEEKDAY(TODAY()) + 4) gives the date of Wednesday of this week.
Return Value
This function returns a Date value that gives the current date.
Learn more about TODAY
TIMENOW
The current time is returned by the TIMENOW function.
Syntax
TIMENOW()
Example
TIMENOW() : Current Time
TIMENOW() is equivalent to TIME(NOW()). See also: NOW(), TIME().
(TIMENOW() - 1) gives the time one hour in the past.
(TIMENOW() + 1) gives the time one hour in the future.
(TIMENOW() + 24) gives the time one day in the future.
Return Value
This function returns the Time value that gives the current time.
WEEKNUM
The week of the year as a number is returned by the WEEKNUM function.
Syntax
WEEKNUM('04/09/1970')
Example
WEEKNUM("1/1/2019") : 1
WEEKNUM("12/31/2019") : 53
WEEKNUM(TODAY()) : Today's week number.
Arguments
Date or DateTime
Return Value
If Date or Date time is recognizable, the week of the year as a number (1 to 53) is returned, else 0 is returned.
Learn more about WEEKNUM
WEEKDAY
The day of the week as a number is returned using the WEEKDAY function.
Syntax
WEEKDAY('04/09/1970')
Example
WEEKDAY('01/01/2019') : 3
WEEKDAY(TODAY()) : Today's numeric day of the week.
WEEKDAY("1/1/2019") : 3
WEEKDAY(TODAY()) : Today's numeric day of the week.
(TODAY() - WEEKDAY(TODAY())) : Date of Saturday last week.
(TODAY() - WEEKDAY(TODAY()) + 7 + 5) : Date of Thursday next week.
Arguments
Date or DateTime
Return Value
If Date or DateTime contains a recognizable data, the day of the week as a number (1 to 7, where 1 is Sunday) is returned, else 0 is returned.
Learn more about WEEKDAY
DATETIME
Users are provided with an option to select date and time using the DATETIME function. This function, then returns the exact date and time.
Syntax
DATETIME(value-to-convert-to-date-time)
Example
DATETIME([Receiver ID]) : The value will be extracted from the Receiver ID column and the same will be reflected where the formula has been applied
DATETIME("4/1/2010 3:14"): 4/1/2010 3:14:00
DATETIME(NOW()) : The current date & time from a DateTime value.
DATETIME("4/1/2010") : 4/1/2010 12:00:00 (a Date value has no time component, so a default is used).
DATETIME(TODAY()) : Today's date at 12:00:00 AM from a Date value (TODAY() returns a Date value, which has no time component, so a default is used).
Arguments
Date, DateTime, or Time
Note: Any textual value may be supplied to DATETIME() since temporal types are Text values with specific formats, but a blank result may be produced by non-temporal values.
Return Value
If DateTime is identifiable, the specified DateTime will return, else blank will return.
TIME
Users are provided with an option to select time using the TIME function. This function, then returns the exact time.
Syntax
TIME(value-to-convert-to-time)
Example
TIME([Receiver ID]): The value will be extracted from the Receiver ID column and the same will be reflected where the formula has been applied
TIME("3:15") (24-hour time): 3:15:00
TIME(TIMENOW()) : The current time from a Time value.
TIME("4/1/2010 3:14") : 3:14:00
TIME(NOW()) : The current time from a DateTime value.
Arguments
Date, DateTime, or Time
Note: Any textual value may be supplied to DATETIME() since temporal types are Text values with specific formats, but a blank result may be produced by non-temporal values.
Return Value
If DateTime is identifiable, specified time is returned, else blank is returned.
Learn more about TIME
DATE
Users are provided with an option to select a date using the DATETIME function. This function, then returns the exact date.
Syntax
DATE(value-to-convert-to-date)
Example
DATE([Receiver ID]): The value will be extracted from the Receiver ID column and the same will be reflected where the formula has been applied
DATE(TODAY()) : Today's date from a Date value.
DATE("4/1/2010 3:14") : 4/1/2010
DATE(NOW()) : Today's date from a DateTime value.
Learn more about DATE
YEAR
The year in the date will only be returned by the YEAR function.
Syntax
YEAR([Date Received])
Example
YEAR([Date Received]): The value will be extracted from the column and the same will be reflected where the formula has been applied
YEAR('04/09/1970') : 1970
YEAR(TODAY()) : This year.
Arguments
Date, DateTime, or Time
Return Value
If the year as specified by Date or DateTime is identifiable, specified number will return. A fixed default year will return in case of a Time value, and 0 if a year is otherwise not found.
Learn more about YEAR
MONTH
The MONTH function returns the month in the date only.
Syntax
MONTH([Date Received])
Example
MONTH([Date Received]) : The value will be extracted from the column and the same will be reflected where the formula has been applied
MONTH('04/22/1970') = 04
MONTH(TODAY()) : This month.
Arguments
Date, DateTime, or Time
Return Value
If the month of the year (1 to 12) as specified by Date or DateTime is identifiable, a specified number will return. A fixed default month will return in case of Time value, and 0 if a month is otherwise not found.
Learn more about MONTH
MINUTE
The number of whole minutes in time will only be returned by the MINUTE function.
Syntax
MINUTE(duration/Time)
Example
MINUTE("02:50:44") = 50
Arguments
Return Value
If the number of whole minutes explicitly specified in duration is identifiable, specified number is returned, and if a minute is not found, 0 is returned.
Learn more about MINUTE
HOUR
The number of hours in time will only be returned by the HOUR function.
Syntax
HOUR(duration/Time)
Example
HOUR("02:50:44") = 02
Arguments
Return Value
If the number of whole hours as specified in duration is identifiable, the specified number is returned, and if an hour is not found, 0 is returned.