# All Functions Alphabetically

## ABS

Returns the absolute value of a number.

## ACOS

Returns the arccosine of a given number.

## ACOSH

Returns the hyperbolic arccosine of a given number.

## ACOT

Returns the arccotangent of a given number.

## ACOTH

Returns the hyperbolic arccotangent of a given number.

## ADD_TO_DATETIME

Add units a datetime. Negative values will do the same as SUBTRACT_FROM_DATETIME.

## ARABIC

Converts a roman numeral to an arabic number.

## ASIN

Returns the arcsine of a given number.

## ASINH

Returns the hyperbolic arcsine of a given number.

## ASSET_TO_URI

Returns the asset URI for the given asset.

## ATAN

Returns the arctangent of a given number.

## ATAN2

Returns the arctangent of a given x and y coordinates.

## ATANH

Returns the hyperbolic arctangent of a given number.

## BASE

Converts a number to a string with the given radix.

## BASE64_DECODE

Decodes a string that contains base64 encoded data returning a decoded string. The encoded data must be text.

## BASE64_ENCODE

Encode a string as a base64 encoded string.

## CEILING

Returns number rounded up to the nearest significance.

## COMBIN

Returns the number of combinations for the given number of items.

## COMBINA

Returns the number of combinations for the given number of items, with repetitions

## CONCAT

Take an arbitrary number of strings and join them together.

## CONTAINS

Returns true if certain value is found in the array, false if not.

## COS

Returns the cosine of a given number.

## COSH

Returns the hyperbolic cosine of a given number.

## COT

Returns the cotangent of a given number.

## COTH

Returns the hyperbolic cotangent of a given number.

## CSC

Returns the cosecant of a given number.

## CSCH

Returns the hyperbolic cosecant of a given number.

## CURRENCY

Represents a unit of currency, including the amount and currency code.

## DATE

Creates a date.

## DATE_DELTA

Returns the number of years, months, days between two dates.

## DATE_FROM_DATETIME

Get the date from a dateTime.

## DATE_FROM_FORMAT

Given a date string return a date.

## DATETIME

Combine a date and time into a datetime.

## DATETIME_DELTA

Returns the number of years, months, days, hours, minutes, seconds between two datetimes.

## DATETIME_FROM_FORMAT

Given a string and format, produce a datetime

## DATETIME_FROM_TIMESTAMP

Convert a timestamp into a datetime object

## DAY

Returns the day of the month.

## DAYS

Returns the number of days between two dates.

## DEGREES

Converts radians into degrees.

## EVEN

Rounds a number up to the nearest even integer.

## EXP

Returns e raised to the power of number.

## FACT

Returns the factorial of a number

## FACT_FLOAT

Returns the factorial of a floating point number

## FLAT

Takes a list of items, and reduces them to a single level list.

## FLOOR

Returns number rounded down to the nearest significance.

## FORMAT_PHONE

take in a phone number string and format the output to the corresponding format.

## FORMAT_CURRENCY

Take a currency and local format and create a formatted string.

## FORMAT_DATE

Produce a formatted string from a date object.

## FORMAT_DATETIME

Produce a formatted string from a datetime.

## FORMAT_NUMBER

Given a number and a local, produce a correctly formatted number string

## FORMAT_TIME

Produce a formatted string from a time.

## FROM_JSON

Convert a valid JSON string into an Airscript value.

## GCD

Returns the greatest common divisor of two or more numbers.

## HOUR

Returns the hour of the datetime or time from 0-23.

## IDENTIFIER_FROM_ASSET

Returns the identifier string for the given asset.

## IF

Use the IF function to do conditional branching.

## ISEMAIL

Determines if the given value is a valid email address.

## ISEMPTY

Returns TRUE if the object, string, or list is empty, otherwise returns FALSE.

## ISEVEN

Determines if a number is even or not.

## ISNOTEMPTY

Returns a true if the object, string, or list is NOT empty.

## ISNUMBER

Determines if the given value is a number.

## ISO_WEEK

Returns the ISO week number of the year. (1-54)

## ISODD

Determines if a number is odd or not.

## ISPHONE

Determines if the given value is a valid phone number.

## ISSTRING

Determines if the given value is a string.

## JOIN

Combine a list of strings.

## LATLNGDISTANCE

Compute the distance between two lat / long points.

## LCM

Returns the least common multiple of two or more numbers.

## LENGTH

Return the count of items in the list or the length of a string.

## LN

Returns the natural logarithm of a number.

## LOG

Returns the logarithm of a number with the given base.

## LOWERCASE

Return a new string by converting all capital letters to lowercase.

## MAX

Max of all the elements provided.

## MERGE_OBJECTS

Combine objects by adding properties of addtional objects to the combination of the previous objects.

## MIN

Min of all the elements provided.

## MINUTE

Returns the minute of the datetime or time.

## MONTH

Returns the month of the year. (1-12)

## MROUND

Returns a number rounded to the given multiple

## MULTINOMIAL

Returns the ratio of the factorial of a sum of values to the product of factorials.

## NOT

Return the revesed logical value of the input boolean.

## NOW

Get the current date and time.

## ODD

Rounds a number up to the nearest odd integer.

## PADSTRING

Pads a string with a given length, if the given string is longer than the length, the original string is returned.

## PARSE_CURRENCY

Take a currency string and generate a Currency primitive

## PARSE_NUMBER

Converts a string to a number.

## PARSE_PHONE

Converts a string to a phone number.

## PI

The mathematical constant PI (3.14159265358979).

## POWER

Raise a number to a given power

## PRODUCT

Return the product of a list of numbers.

## RADIANS

Converts degrees into radians.

## RANDOM

Return a random number with optional min, max and shouldFloor parameters.

## RANGE

Generates a list from the given start number to the given end number.

## REPLACE

Replace part of a string with a replacement string.

## REPT

Repeats the given string a given number of times.

## ROMAN

Converts a number to Roman numerals

## ROUND

Rounds a number to the given number of digits.

## ROUNDDOWN

Rounds a number down to the given number of digits.

## ROUNDUP

Rounds a number up to the given number of digits.

## SEC

Returns the secant of a given number.

## SECH

Returns the hyperbolic secant of a given number.

## SECOND

Returns the second of the datetime or time.

## SHUFFLE

Given a list of objects, return the objects in a random order.

## SIGN

Determines the sign of a number.

## SIN

Returns the sine of a given number.

## SINH

Returns the hyperbolic sine of a given number.

## SPLIT

Given a string and a separator, return a list of strings broken by the separator.

## SQRT

Returns the square root

## SQRTPI

Returns the square root of (number * pi)

## STRING_COMPARE

Used to compare strings and return their lexical order.

## STRING_FIND

Returns the index or -1 of search string found in the string.

## STRIP

Strips out the given characters from the string.

## SUBSTITUTE

Replaces all occurences of a given string with another.

## SUBSTRING

Get the substring of from a string starting at a given index.

## SUBTRACT_FROM_DATETIME

Subtract units from the a datetime object. Negative values will do the same as ADD_TO_DATETIME.

## SUM

Sum of all the elments provided.

## SUMSQ

Returns the sum of squares of the given numbers

## TAN

Returns the tangent of a given number.

## TANH

Returns the hyperbolic tangent of a given number.

## TIME

Creates a time.

## TIME_DELTA

Returns the number of hours, minutes, seconds between two times.

## TIME_FROM_DATETIME

Get the time from a datetime.

## TIME_FROM_FORMAT

Given a date time string and a format return a time.

## TIMESTAMP_FROM_DATETIME

Get the value of a datetime in timestamp format.

## TITLECASE

Return a string by converting the first character of each space separated word of the input string to upper case. Capital letters in your base string will stop the capitalization.

## TO_JSON

Convert an Airscript value into a JSON string.

## TODAY

Returns today as a date.

## TRIM

Return the leading and trailing whitespace from a string.

## TRUNC

Removes the fractional part of a number

## TYPEOF

Determines the type of the given value.

## UPDATE_DATE

Modify a datetime to a new date.

## UPDATE_DATETIME

Modify an input datetime.

## UPDATE_DAY

Modify a datetime or date to a new day.

## UPDATE_HOUR

Modify a datetime or time to a new hour.

## UPDATE_MILLISECOND

Modify a datetime or time to a new millisecond.

## UPDATE_MINUTE

Modify a datetime or time to a new minute.

## UPDATE_MONTH

Modify a datetime or date to a new month.

## UPDATE_SECOND

Modify a datetime or time to a new second.

## UPDATE_TIME

Modify a datetime to a new time.

## UPDATE_TIMEZONE

Modify a datetime object to a new timezone.

## UPDATE_YEAR

Modify a datetime or date to a new year.

## UPPERCASE

Return the lowercase representation of a string.

## URI_TO_ASSET

Returns the asset for a given asset URI.

## URL_DECODE

Decode a URL

## URL_ENCODE

Encode a URL.

## VALUES

Get the values from all the object's keys.

## WEEK

Returns the week number of the year. (1-54)

## WEEKDAY

Returns the day of the week. (1-7)

## YEAR

Returns the 4-digit year.