date

Add_duration

Returns a new datetime by adding a number of given units to the original datetime, such as 1 day or 7 hours. Valid units are: years , months , dates , hours , minutes , seconds or milliseconds . Function signature ADD_DURATION(date: S...

Updated on : 18 May 2022

Datetime_difference

Returns the difference between the given two datetimes in the given unit of time. Function signature DATETIME_DIFFERENCE(date1: String, date2: String, units: String = milliseconds, indecimal: Boolean) => Number Parameter Description...

Updated on : 18 May 2022

Datetime_is_after

Returns true if the first datetime is after the second datetime, otherwise returns false . Function signature DATETIME_IS_AFTER(date1: String, date2: String, precision: String) => Boolean Parameter Description Date 1 ...

Updated on : 18 May 2022

Datetime_is_before

Returns true if the first datetime is before the second datetime, otherwise returns false . Function signature DATETIME_IS_BEFORE(date1: String, date2: String, precision: String) => Boolean Parameter Description Date 1 ...

Updated on : 18 May 2022

Datetime_is_between

Returns true if a datetime is between the given other two datetimes, and false otherwise. By default, returns false if the datetime is exactly same as either of the boundary datetimes. This behavior can be modified by providing the optional ...

Updated on : 18 May 2022

Datetime_is_same_or_after

Returns true if the first datetime is the same or after the second datetime, otherwise returns false . Function signature DATETIME_IS_SAME_OR_AFTER(date1: String, date2: String, precision: String) => Boolean Parameter Description...

Updated on : 18 May 2022

Datetime_is_same_or_before

Returns true if the first datetime is the same or before the second datetime, otherwise returns false . Function signature DATETIME_IS_SAME_OR_BEFORE(date1: String, date2: String, precision: String) => Boolean Parameter Descripti...

Updated on : 18 May 2022

Datetime_is_same

Returns true if the two given datetimes are exactly the same, otherwise returns false . Function signature DATETIME_IS_SAME(date1: String, date2: String, precision: String) => Boolean Parameter Description Date 1 Date...

Updated on : 18 May 2022

Datetime

Convert a valid date/datetime text, or a number representing milliseconds since the Unix Epoch (1 January, 1970 UTC), to an ISO 8601 formatted text representation. Function signature DATETIME(timestamp: Number|String, dateformat: String) => Str...

Updated on : 18 May 2022

Format_datetime_local

Returns the given DateTime formatted into a human readable text. Follows the latest Moment.js syntax. The formatted text takes the current timezone of the device into account, so e.g. a date returned by a server in UTC +0 is formatted correctly to...

Updated on : 18 May 2022

Format_datetime_with_timezone

Returns the given datetime formatted into a human readable text. The formatted text takes the given timezone into account, adjusting the output accordingly. Function signature FORMAT_DATETIME_WITH_TIMEZONE(date: String, format: String, timezo...

Updated on : 18 May 2022

Get_datetime_component

For the given datetime, returns the given component: year , month , date , hour , minute , second or millisecond . Function signature GET_DATETIME_COMPONENT(date: String, component: String) => Number Parameter Description ...

Updated on : 18 May 2022

Is_datetime

Returns true if the given text is a valid datetime, and false otherwise. Function signature IS_DATETIME(value: String) => Boolean Parameter Description Value Value to check Examples Formula Return v...

Updated on : 18 May 2022

Local_timezone

Returns the current local timezone of the device running the app. Function signature LOCAL_TIMEZONE() => String Examples Formula Return value LOCAL_TIMEZONE() US/Central

Updated on : 18 May 2022

Now

Returns the current datetime as an ISO 8601 text. Optionally, the current datetime can be returned as a human-readable text by providing a datetime format parameter. Function signature NOW(format: String) => String Parameter Descr...

Updated on : 18 May 2022

Set_datetime_component

Returns the given datetime with a given component changed to a new value. Valid components are: year , month , date , hour , minute , second or millisecond . Note that the value is changed in the timezone in which the given datetime is spe...

Updated on : 18 May 2022

Set_timezone

Returns a datetime that represents the given datetime in another timezone. Function signature SET_TIMEZONE(date: String, timezone: String) => String Parameter Description Date Date to convert Timezone Timezone to...

Updated on : 18 May 2022

Subtract_duration

Returns a new datetime by subtracting a number of given units from the original datetime, such as 1 day or 7 hours. Valid units are: years , months , dates , hours , minutes , seconds or milliseconds . Function signature SUBTRACT_DURA...

Updated on : 18 May 2022

Timestamp

Converts the given datetime into the number of milliseconds since the Unix Epoch (1st January, 1970 UTC). Function signature TIMESTAMP(date: String) => Number Parameter Description Date Date to convert Examples ...

Updated on : 18 May 2022

Timezone

Returns the timezone of the given datetime. Function signature TIMEZONE(date: String) => String Parameter Description Date Date to receive timezone Examples Formula Return value TIMEZONE("201...

Updated on : 18 May 2022

Yearfrac

Returns the difference in years between the given two datetimes. Fractional year differences are represented as a decimal number. Optionally, you can change the convention for how the number of days in a year is counted. Function signature YE...

Updated on : 18 May 2022