Time Expression In Appy Pie App Sheet Feature

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

• Duration: The number of minutes

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

• Duration: The number of hours

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.