Returns the absolute value of a number without regard to its sign

Adds a specified number of days to a date value

Adds a specified number of hours to a date value

Adds a specified number of minutes to a date value

Adds a specified number of months to a date value

Adds a specified number of quarters to a date value

Adds a specified number of seconds to a date value

Adds a specified number of weeks to a date value

Adds a specified number of years to a date value

Tests if a value is between two specified values

Rounds a number up to the nearest specified multiple

Returns a number from 1 to 31 that represents the day of the month

Calculates the number of days between two date values

Calculates the number of hours between two date values

Calculates the number of minutes between two date values

Calculates the number of months between two date values

Calculates the number of quarters between two date values

Calculates the number of seconds between two date values

Calculates the number of weeks between two date values

Calculates the number of years between two date values

Finds the location of a substring in a string

Returns one value if a specified condition evaluates to true, or another value if the condition evaluates to false

Tests if a value is equal to a value in a list

Tests if a value in a specified field is a null value

Extracts a substring from a string, starting from the left‑most, or first, character

Counts the number of characters in a string

Tests if a string matches a pattern

Converts all letters in a string to lowercase

Tests if a string matches a pattern

Returns the remainder after a number is divided by another

Returns the month for a specified date value

Negates a Boolean expression

Tests if a value in a specified field is a non‑null value

Returns the current date and time

Returns the quarter number for a specified date value

Extracts a substring from a string, starting from the right‑most, or last, character

Rounds a number to a specified number of digits

Rounds a number down to a specified number of digits

Rounds a number up to a specified number of digits

Finds the location of a substring in a string

Calculates the square root of a number

Returns the current date

Removes the leading and trailing blanks from a specified string

Removes the leading blanks from a specified string

Removes the trailing blanks from a specified string

Converts all letters in a string to uppercase

Returns a number from 1 to 52 that represents the week of the year

Returns the day of the week for a specified date value

Returns the four‑digit year value for a specified date value