Text Functions (9) 
Name 
Arguments 
Return 
Description 
Chr 
NUMBER ascii_code 
TEXT 
Returns a onecharacter text value containing the character specified by ascii. 
Category: 
Text Functions 
Name: 
Chr 
Arguments: 
NUMBER ascii_code 
Return Type: 
TEXT 
Description: 
Returns a onecharacter text value containing the character
specified by ascii.

Examples: 
Chr(65) will return “A” 

ConCat 

TEXT 
Returns the merged text value of all the arguments. 
Category: 
Text Functions 
Name: 
ConCat 
Arguments: 

Return Type: 
TEXT 
Description: 
Returns the merged text value of all the arguments. 
Examples: 
ConCat(“abc”,”def”,”ghi”) returns “abcdefghi” 

LTrim 
TEXT text, [TEXT character_mask] 
TEXT 
Strip whitespace (or other characters) from the beginning of a text value. 
Category: 
Text Functions 
Name: 
LTrim 
Arguments: 
TEXT text, [TEXT character_mask] 
Return Type: 
TEXT 
Description: 
Strip whitespace (or other characters) from the beginning of a
text value.

Examples: 
LTrim(” abc “) will return “abc “ LTrim(“–abc—“, ““)
will return “abc—”


Num 
TEXT text 
NUMBER 
Converts a text value to number if the text value contains only numeric characters and a decimal
point.

Category: 
Text Functions 
Name: 
Num 
Arguments: 
TEXT text 
Return Type: 
NUMBER 
Description: 
Converts a text value to number if the text value contains only
numeric characters and a decimal point.

Examples: 
Num(“8950”) will return 8950 in numeric form 

RTrim 
TEXT text, [TEXT character_mask] 
TEXT 
Strip whitespace (or other characters) from the end of a text value. 
Category: 
Text Functions 
Name: 
RTrim 
Arguments: 
TEXT text, [TEXT character_mask] 
Return Type: 
TEXT 
Description: 
Strip whitespace (or other characters) from the end of a text
value.

Examples: 
RTrim(” abc “) will return ” abc” RTrim(“–abc—“, ““)
will return “–abc”


Str 
DATABASE_FIELD/MIXED variable 
TEXT 
Returns text value of a variable. 
Category: 
Text Functions 
Name: 
Str 
Arguments: 
DATABASE_FIELD/MIXED variable 
Return Type: 
TEXT 
Description: 
Returns text value of a variable. 
Examples: 
Str(“12345”) returns “12345” in text form 

StrLen 
TEXT_FIELD/TEXT text 
NUMBER 
Returns the length of the given text value. 
Category: 
Text Functions 
Name: 
StrLen 
Arguments: 
TEXT_FIELD/TEXT text 
Return Type: 
NUMBER 
Description: 
Returns the length of the given text value. 
Examples: 
StrLen(“Hello World”) returns 11 

SubStr 
TEXT_FIELD/TEXT text, NUMBER start, [NUMBER length] 
TEXT 
Return part of a text value. 
Category: 
Text Functions 
Name: 
SubStr 
Arguments: 
TEXT_FIELD/TEXT text, NUMBER start, [NUMBER length] 
Return Type: 
TEXT 
Description: 
Returns the portion of text value specified by the start and
length parameters.
TEXT_FIELD/TEXT text The input text value. Must be
one character or longer.
INTEGER start If start is nonnegative, the
returned text value will start at the start’th position in text value, counting from
zero. For instance, in the text value ‘abcdef’, the character at position 0 is ‘a’, the
character at position 2 is ‘c’, and so forth.
If start is negative, the returned
text value will start at the start’th character from the end of text value.
If
text value is less than start characters long, FALSE will be returned.
INTEGER
length If length is given and is positive, the text value returned will
contain at most length characters beginning from start (depending on the length of text
value).
If length is given and is negative, then that many characters will be
omitted from the end of text value (after the start position has been calculated when a
start is negative). If start denotes the position of this truncation or beyond, FALSE
will be returned.
If length is given and is 0, FALSE or NULL, an empty text value
will be returned.
If length is omitted, the substring starting from start until
the end of the text value will be returned.

Examples: 
substr(“abcdef”, 0, 2) returns “ab” substr(“abcdef”, 1)
returns “f” substr(“abcdef”, 2) returns “ef” substr(“abcdef”, 3, 1) returns
“d”


Trim 
TEXT text, [TEXT character_mask] 
TEXT 
Strip whitespace (or other characters) from the beginning and end of a text value. 
Category: 
Text Functions 
Name: 
Trim 
Arguments: 
TEXT text, [TEXT character_mask] 
Return Type: 
TEXT 
Description: 
Strip whitespace (or other characters) from the beginning and
end of a text value.

Examples: 
Trim(” abc “) will return “abc” Trim(“—abc–“, ““) will
return “abc”


Number Functions (21) 
Name 
Arguments 
Return 
Description 
Abs 
NUMBER N 
NUMBER 
Returns the absolute value of number N 
Category: 
Number Functions 
Name: 
Abs 
Arguments: 
NUMBER N 
Return Type: 
NUMBER 
Description: 
Returns the absolute value of number N 
Examples: 
Abs(4.2) will return 4.2 Abs(5) will return 5 

ATan 
NUMBER N 
NUMBER 
Returns the arc tangent of number N in radians 
Category: 
Number Functions 
Name: 
ATan 
Arguments: 
NUMBER N 
Return Type: 
NUMBER 
Description: 
Returns the arc tangent of number N in radians. ATan() is the
complementary function of Tan(), which means that a == Tan(ATan(a)) for every value of a
that is within ATan()’s range.

Examples: 
ATan(50) will return 1.5507989928217 

Ceil 
NUMBER N 
NUMBER 
Returns the next highest integer value by rounding up value if necessary. 
Category: 
Number Functions 
Name: 
Ceil 
Arguments: 
NUMBER N 
Return Type: 
NUMBER 
Description: 
Returns the next highest integer value by rounding up value if
necessary.

Examples: 
Ceil(5.2) will return 6 Ceil(2.4) will return 3 

Cos 
NUMBER N 
NUMBER 
Returns the cosine of the number N 
Category: 
Number Functions 
Name: 
Cos 
Arguments: 
NUMBER N 
Return Type: 
NUMBER 
Description: 
Returns the cosine of the number N. The number N is in
radians.

Examples: 
Cos(50) will return 0.96496602849211 

Cosh 
NUMBER N 
NUMBER 
Returns the hyperbolic cosine of number N 
Category: 
Number Functions 
Name: 
Cosh 
Arguments: 
NUMBER N 
Return Type: 
NUMBER 
Description: 
Returns the hyperbolic cosine of number N, defined as (Exp(N) +
Exp(N))/2.

Examples: 
Cosh(2) will return 3.7621956910836 

CoTan 
NUMBER N 
NUMBER 
Returns the cotangent of number N 
Category: 
Number Functions 
Name: 
CoTan 
Arguments: 
NUMBER N 
Return Type: 
NUMBER 
Description: 
Returns the cotangent of number N, defined as 1/Tan(N). The
number N is in radians.

Examples: 
CoTan(2) will return 0.45765755436029 

Exp 
NUMBER N 
NUMBER 
Returns e raised to the power of number N 
Category: 
Number Functions 
Name: 
Exp 
Arguments: 
NUMBER N 
Return Type: 
NUMBER 
Description: 
Returns e raised to the power of number N. ‘e’ is the base of
the natural system of logarithms, or approximately 2.718282.

Examples: 
Exp(2) will return 7.3890560989307 

Floor 
NUMBER N 
NUMBER 
Returns the next lowest integer value (as float) by rounding down value if necessary. 
Category: 
Number Functions 
Name: 
Floor 
Arguments: 
NUMBER N 
Return Type: 
NUMBER 
Description: 
Returns the next lowest integer value (as float) by rounding
down value if necessary.

Examples: 
Floor(5.2) will return 4 Floor(2.4) will return 2 

Ln 
NUMBER N 
NUMBER 
Returns natural log of the number N 
Category: 
Number Functions 
Name: 
Ln 
Arguments: 
NUMBER N 
Return Type: 
NUMBER 
Description: 
Returns natural log of the number N 

Log10 
NUMBER N 
NUMBER 
Returns the base10 logarithm of number N 
Category: 
Number Functions 
Name: 
Log10 
Arguments: 
NUMBER N 
Return Type: 
NUMBER 
Description: 
Returns the base10 logarithm of number N 

Logn 
NUMBER base, NUMBER N 
NUMBER 
Returns the log base of number N 
Category: 
Number Functions 
Name: 
Logn 
Arguments: 
NUMBER base, NUMBER N 
Return Type: 
NUMBER 
Description: 
Returns the log base of number N 
Examples: 
Logn(10, 100) return 2 

Pow 
NUMBER base, NUMBER exp 
NUMBER 
The Power function raises Base to any power. 
Category: 
Number Functions 
Name: 
Pow 
Arguments: 
NUMBER base, NUMBER exp 
Return Type: 
NUMBER 
Description: 
The Power function raises Base to any power. For fractional
exponents or exponents greater than MaxInt, Base must be greater than 0.

Examples: 
Pow(2, 5) return 32 Pow(4.1, 3) return 68.921 

Rnd 

NUMBER 
Generates a random number (float value) between 0 and 1. 
Category: 
Number Functions 
Name: 
Rnd 
Arguments: 

Return Type: 
NUMBER 
Description: 
Generates a random number (float value) between 0 and 1. 

Sign 
NUMBER N 
NUMBER 
Returns the signed value of number N 
Category: 
Number Functions 
Name: 
Sign 
Arguments: 
NUMBER N 
Return Type: 
NUMBER 
Description: 
Returns the signed value of number N 
Examples: 
Sign(X) returns 1 if X < 0, +1 if X > 0, 0 if X=0.
It can be used as Sqr(X)


Sin 
NUMBER N 
NUMBER 
Returns the sine of the number N 
Category: 
Number Functions 
Name: 
Sin 
Arguments: 
NUMBER N 
Return Type: 
NUMBER 
Description: 
Returns the sine of the number N. The number N is in radians.

Examples: 
Sin(50) will return 0.26237485370393 

Sinh 
NUMBER N 
NUMBER 
Returns the hyperbolic sine of number N 
Category: 
Number Functions 
Name: 
Sinh 
Arguments: 
NUMBER N 
Return Type: 
NUMBER 
Description: 
Returns the hyperbolic sine of number N, defined as (exp(N) –
exp(N))/2.

Examples: 
Sinh(2) will return 3.626860407847 

Sqr 
NUMBER N 
NUMBER 
Returns the square of argument. 
Category: 
Number Functions 
Name: 
Sqr 
Arguments: 
NUMBER N 
Return Type: 
NUMBER 
Description: 
Returns the square of argument. 
Examples: 
Sqr(“7”) will return 49 

Sqrt 
NUMBER N 
NUMBER 
Returns the square root of number N 
Category: 
Number Functions 
Name: 
Sqrt 
Arguments: 
NUMBER N 
Return Type: 
NUMBER 
Description: 
Returns the square root of number N 
Examples: 
Sqrt(“49”) will return 3 

Tan 
NUMBER N 
NUMBER 
Returns the tangent of the number N 
Category: 
Number Functions 
Name: 
Tan 
Arguments: 
NUMBER N 
Return Type: 
NUMBER 
Description: 
Returns the tangent of the number N. The number N is in
radians.

Examples: 
Tan(2) will return 2.1850398632615 

Trunc 
NUMBER N 
NUMBER 
Discards the fractional part of a number N 
Category: 
Number Functions 
Name: 
Trunc 
Arguments: 
NUMBER N 
Return Type: 
NUMBER 
Description: 
Discards the fractional part of a number N 
Examples: 
TRUNC(3.2) will return 3 TRUNC(3.2) will return 3 

Val 
TEXT argument 
NUMBER 
Returns the floating point numeric value of the text value. 
Category: 
Number Functions 
Name: 
Val 
Arguments: 
TEXT argument 
Return Type: 
NUMBER 
Description: 
Returns the floating point numeric value of the text value.

Examples: 
Val(“3.1”) return 3.1 

Date Functions (16) 
Name 
Arguments 
Return 
Description 
Make_Date 
NUMBER year, NUMBER month, NUMBER day, [NUMBER hour], [NUMBER minute], [NUMBER second] 
DATE 
Creates a date from given year, month, day, hour, minute, and second. 
Category: 
Date Functions 
Name: 
Make_Date 
Arguments: 
NUMBER year, NUMBER month, NUMBER day, [NUMBER hour], [NUMBER
minute], [NUMBER second]

Return Type: 
DATE 
Description: 
Creates a date from given year, month, day, hour, minute, and
second.

Examples: 
Make_Date(2009, 3, 12) will create a date with value 12th March
2009. If time is not specified, then midnight time is taken as default.


Date 
TEXT format, [DATEFIELD/TIMESTAMP t] 
TEXT 
Returns a text formatted according to the given format text using the given integer Timestamp or
Database Date Field. Timestamp is optional and defaults to the value of current time.

Category: 
Date Functions 
Name: 
Date 
Arguments: 
TEXT format, [DATEFIELD/TIMESTAMP t] 
Return Type: 
TEXT 
Description: 
Returns a text formatted according to the given format text
using the given integer Timestamp or Database Date Field. Timestamp is optional and
defaults to the value of current time.
The following characters are recognized in
the format parameter text.
Format Character 
Description 
Example returned values 
Day 
d 
Day of the month, 2 digits with leading zeros 
01 to 31 
D 
A textual representation of a day, three letters 
Mon through Sun 
j 
Day of the month without leading zeros 
1 to 31 
l (lowercase ‘L’) 
A full textual representation of the day of the week 
Sunday through Saturday 
N 
ISO8601 numeric representation of the day of the week (added inPHP 5.1.0)

1 (for Monday) through 7 (for Sunday) 
S 
English ordinal suffix for the day of the month, 2 characters 
st, nd, rd orth. Works well with
j 
w 
Numeric representation of the day of the week 
0 (for Sunday) through 6 (for Saturday) 
z 
The day of the year (starting from 0) 
0 through 365 
Week 
W 
ISO8601 week number of year, weeks starting on Monday (added in PHP
4.1.0)

Example: 42 (the 42nd week in the year) 
Month 
F 
A full textual representation of a month, such as January or March 
January through December 
m 
Numeric representation of a month, with leading zeros 
01 through 12 
M 
A short textual representation of a month, three letters 
Jan through Dec 
n 
Numeric representation of a month, without leading zeros 
1 through 12 
t 
Number of days in the given month 
28 through 31 
Year 
L 
Whether it’s a leap year 
1 if it is a leap year, 0 otherwise. 
o 
ISO8601 year number. This has the same value asY, except that if
the ISO week number(W) belongs to the previous or next year, that
yearis used instead. (added in PHP 5.1.0)

Examples: 1999 or 2003 
Y 
A full numeric representation of a year, 4 digits 
Examples: 1999 or 2003 
y 
A two digit representation of a year 
Examples: 99 or 03 
Time 
a 
Lowercase Ante meridiem and Post meridiem 
am or pm 
A 
Uppercase Ante meridiem and Post meridiem 
AM or PM 
B 
Swatch Internet time 
000 through 999 
g 
12hour format of an hour without leading zeros 
1 through 12 
G 
24hour format of an hour without leading zeros 
0 through 23 
h 
12hour format of an hour with leading zeros 
01 through 12 
H 
24hour format of an hour with leading zeros 
00 through 23 
i 
Minutes with leading zeros 
00 to 59 
s 
Seconds, with leading zeros 
00 through 59 
u 
Microseconds (added in PHP 5.2.2). Note thatdate()
will always generate000000 since it takes an integerparameter,
whereas DateTime::format()
doessupport microseconds if DateTime
wascreated with microseconds.

Example: 654321 
Timezone 
e 
Timezone identifier (added in PHP 5.1.0) 
Examples: UTC, GMT, Atlantic/Azores 
I (capital i) 
Whether or not the date is in daylight saving time 
1 if Daylight Saving Time, 0 otherwise. 
O 
Difference to Greenwich time (GMT) in hours 
Example: +0200 
P 
Difference to Greenwich time (GMT) with colon between hours and minutes
(added in PHP 5.1.3)

Example: +02:00 
T 
Timezone abbreviation 
Examples: EST, MDT … 
Z 
Timezone offset in seconds. The offset for timezones west of UTC is
alwaysnegative, and for those east of UTC is always positive.

43200 through 50400 
Full Date/Time 
c 
ISO 8601 date 
20040212T15:19:21+00:00 
r 
RFC 2822 formatted date 
Example: Thu, 21 Dec 2000 16:01:07 +0200 
U 
Seconds since the Unix Epoch (January 1 1970 00:00:00 GMT) 


Examples: 
date(“dMY”, now()) returns 16Sep2015 

Now 

NUMBER 
Returns current timestamp. 
Category: 
Date Functions 
Name: 
Now 
Arguments: 

Return Type: 
NUMBER 
Description: 
Returns a 10 digit current timestamp. 
Examples: 
Now() will return 1442401200 for 16Sep2015 11:00AM 

Date_Add 
DATEFIELD/TIMESTAMP t, NUMBER n, [TEXT t] 
NUMBER 
Performs arithmetic operation on date by adding years, months, weeks, days, hours, minutes, and
seconds.

Category: 
Date Functions 
Name: 
Date_Add 
Arguments: 
DATEFIELD/TIMESTAMP t, NUMBER n, [TEXT t] 
Return Type: 
NUMBER 
Description: 
Performs arithmetic operation on date by adding years, months,
weeks, days, hours, minutes, and seconds.
Format Character 
Description 
Example returned values 
d 
days 
Date_Add(input_date, 2, “d”) will add two days to input date 
m 
months 
Date_Add(input_date, 1, “m”) will substract one month from input date 
y 
years 
Date_Add(input_date, 1, “y”) will add one year to input date 
w 
weeks 
Date_Add(input_date, 3, “w”) will add three weeks to input date 
h 
hours 
Date_Add(input_date, 12, “h”) will add twelve hours to input date 
min 
minutes 
Date_Add(input_date, 30, “min”) will substract thrity minutes from input
date

s 
seconds 
Date_Add(input_date, 120, “h”) will add one hundred twenty seconds to input
date


Examples: 
Date_Add(input_date, 2, “d”) will add two days to input
date Date_Add(Make_Date(2015, 2, 12), 10, “d”)) will return 22nd of February 2015


DateTime_Diff 
DATEFIELD/TIMESTAMP start, DATEFIELD/TIMESTAMP end 
NUMBER 
This function gives the to seconds between two dates. 
Category: 
Date Functions 
Name: 
DateTime_Diff 
Arguments: 
DATEFIELD/TIMESTAMP start, DATEFIELD/TIMESTAMP end 
Return Type: 
NUMBER 
Description: 
This function gives the to seconds between two dates. 
Examples: 
DateTime_Diff([Start_Date], [End_Date]) will return total
seconds between Start_Date and End_Date DateTime_Diff(Make_Date(2015, 2, 12),
Make_Date(2015, 2, 22)) will return 864000


Add_Months 
DATE d, NUMBER m 
DATE 
Add months to a date. 
Category: 
Date Functions 
Name: 
Add_Months 
Arguments: 
DATE d, NUMBER m 
Return Type: 
DATE 
Description: 
Adds m months to date d and returns the date. It preserves the
day of the original date. If that day is not in the new date, then last day of that
month is returned.

Examples: 
Add_Months([Sales_Date], 2) will return a date which is two
months after Sales_Date field Add_Months(Make_Date(2015, 5, 12), 2) will 12th July
2015 as date


Add_Years 
DATE d, NUMBER y 
DATE 
Add years to a date. 
Category: 
Date Functions 
Name: 
Add_Years 
Arguments: 
DATE d, NUMBER y 
Return Type: 
DATE 
Description: 
Adds y years to date d and returns the date. It preserves the
day of the original date. If that day is not in the new month of the new date, then last
day of that month is returned.

Examples: 
Adjust_Years([Sales_Date], 2) will return a date which is two
years after Sales_Date field Adjust_Years(Make_Date(2014, 1, 14), 2) will 14th
January 2016 as date


Day 
DATE d 
NUMBER 
Returns the day of the month of the Date d. 
Category: 
Date Functions 
Name: 
Day 
Arguments: 
DATE d 
Return Type: 
NUMBER 
Description: 
Returns the day of the month of the Date d. 
Examples: 
Day(Make_Date(2015, 3, 28)) will 28 

Day_Of_Week 
DATE d 
NUMBER 
Returns the number of days by which the given date d follows the first day of the week (Sunday returns
0).

Category: 
Date Functions 
Name: 
Day_Of_Week 
Arguments: 
DATE d 
Return Type: 
NUMBER 
Description: 
Returns the number of days by which the given date d follows
the first day of the week (Sunday returns 0).

Examples: 
Day_Of_Week(Make_Date(2015, 9, 26)) returns 6 (Saturday) Day_Of_Week(Make_Date(2015,
1, 30)) returns 5 (Friday)


Day_Of_Year 
DATE d 
NUMBER 
Returns the number of days by which the given date d follows the first day of the year (January 1
returns 0).

Category: 
Date Functions 
Name: 
Day_Of_Year 
Arguments: 
DATE d 
Return Type: 
NUMBER 
Description: 
Returns the number of days by which the given date d follows
the first day of the year (January 1 returns 0).

Examples: 
Day_Of_Year(Make_Date(2015, 9, 29)) returns 271 Day_Of_Year(Make_Date(2015,
12, 9)) returns 342


First_Day_Of_Month 
DATE d 
DATE 
Returns the first day of the month in which the date falls. 
Category: 
Date Functions 
Name: 
First_Day_Of_Month 
Arguments: 
DATE d 
Return Type: 
DATE 
Description: 
Returns the first day of the month in which the date falls.

Examples: 
First_Day_Of_Month(Make_Date(2015, 10, 13)) 1st October 2015 as
Date


First_Day_Of_Year 
DATE d 
DATE 
Returns the first day of the year in which the date falls. 
Category: 
Date Functions 
Name: 
First_Day_Of_Year 
Arguments: 
DATE d 
Return Type: 
DATE 
Description: 
Returns the first day of the year in which the date falls. 
Examples: 
First_Day_Of_Year(Make_Date(2015, 7, 17)) 1st July 2015 as
Date


First_Day_Of_Week 
DATE d 
DATE 
Returns the first day (Sunday) of the week in which the date falls. 
Category: 
Date Functions 
Name: 
First_Day_Of_Week 
Arguments: 
DATE d 
Return Type: 
DATE 
Description: 
Returns the first day (Sunday) of the week in which the date
falls.

Examples: 
First_Day_Of_Week(Make_Date(2015, 5, 9)) will return 3rd May
2015 as Date


Is_Leap_Day 
DATE d 
BOOLEAN 
Returns true if Date d is 29th of February. 
Category: 
Date Functions 
Name: 
Is_Leap_Day 
Arguments: 
DATE d 
Return Type: 
BOOLEAN 
Description: 
Returns true if Date d is 29th of February. 
Examples: 
Is_Leap_Day(Make_Date(2015, 2, 29)) will return false Is_Leap_Day(Make_Date(2016,
2, 29)) will return true


Is_Leap_Year 
DATE d 
BOOLEAN 
Returns true if the Date d falls in a leap year. 
Category: 
Date Functions 
Name: 
Is_Leap_Year 
Arguments: 
DATE d 
Return Type: 
BOOLEAN 
Description: 
Returns true if the Date d falls in a leap year. 
Examples: 
Is_Leap_Year(Make_Date(2015, 2, 29)) will return false Is_Leap_Year(Make_Date(2016,
2, 29)) will return true


Working_Days_In_A_Month 
DATE d, NUMBER weekend_setting, TEXT holidays 
NUMBER 
Calculates total working days in a month 
Working_Days_In_A_Month
Close
Category: 
Date Functions 
Name: 
Working_Days_In_A_Month 
Arguments: 
DATE d, NUMBER weekend_setting, TEXT holidays 
Return Type: 
NUMBER 
Description: 
Weekend Settings:
1: Saturday, Sunday 2: Sunday 3:
Friday, Saturday
Holidays: Comma separated timestamps

Examples: 
working_days_in_a_month(Make_Date(2016, 3, 1, 0, 0, 0), 1,””)
return 23
working_days_in_a_month(Make_Date(2016, 3, 1, 0, 0, 0), 1,
Make_Date(2016, 3, 23, 0, 0, 0)) return 22 

Formatting Functions (2) 
Name 
Arguments 
Return 
Description 
Format_Number 
NUMBER value, [NUMBER decimal_points], [TEXT decimal_point_character], [TEXT thousands_seperator] 
TEXT 
Format a number with grouped thousands. 
Category: 
Formatting Functions 
Name: 
Format_Number 
Arguments: 
NUMBER value, [NUMBER decimal_points], [TEXT
decimal_point_character], [TEXT thousands_seperator]

Return Type: 
TEXT 
Description: 
Format a number with grouped thousands. 
Examples: 
format_number(12000, 2) returns 12,000.00 format_number(13500.75,
2, “.”, ““) returns 13500.00


Format_Seconds 
NUMBER seconds 
TEXT 
Formats seconds to readable format. 
Category: 
Formatting Functions 
Name: 
Format_Seconds 
Arguments: 
NUMBER seconds 
Return Type: 
TEXT 
Description: 
Formats seconds to readable format. 
Examples: 
Format_Seconds(300) will return 5 minutes Format_Seconds(176600)
will return 2 days 1 hours 3 minutes 20 seconds


Aggregate Functions (3) 
Name 
Arguments 
Return 
Description 
Sum 

NUMBER 
Returns the sum of all the arguments. 
Category: 
Aggregate Functions 
Name: 
Sum 
Arguments: 

Return Type: 
NUMBER 
Description: 
Returns the sum of all the arguments. 
Examples: 
Sum(2, 5, 3, 10) will 20 Sum(2.2, 2.5, 7.4) will return 12.1


Min 

NUMBER 
Returns the minimum number from all the arguments. 
Category: 
Aggregate Functions 
Name: 
Min 
Arguments: 

Return Type: 
NUMBER 
Description: 
Returns the minimum number from all the arguments. 
Examples: 
Min(10, 7, 199, 18) will 7 

Max 

NUMBER 
Returns the maximum number from all the arguments. 
Category: 
Aggregate Functions 
Name: 
Max 
Arguments: 

Return Type: 
NUMBER 
Description: 
Returns the maximum number from all the arguments. 
Examples: 
Max(10, 7, 199, 18) will 199 

Database Functions (1) 
Name 
Arguments 
Return 
Description 
User 

NUMBER 
Returns the current user. The value should be assigned to a Users Field. 
Category: 
Database Functions 
Name: 
User 
Arguments: 

Return Type: 
NUMBER 
Description: 
Returns the current user. The value should be assigned to a
Users Field.

