Formula Functions
The following options are available from the Functions drop-down list in the Saved Formulas window:
Date
|
Function |
Javascript Notation |
Definition |
|---|---|---|
|
Add X Days |
(new Date(…)).addDays(…) |
Add a specified number of days to a date/time field. |
|
Add X Hours |
(new Date(…)).addHours(…) |
Add a specified number of hours to a date/time field. |
|
Add X Minutes |
(new Date(…)).addMinutes(…) |
Add a specified number of minutes to a date/time field. |
|
Add X Months |
(new Date(…)).addMonths(…) |
Add a specified number of months to a date/time field. |
|
Add X Weeks |
(new Date(…)).addWeeks(…) |
Add a specified number of weeks to a date/time field. |
|
Add X Years |
(new Date(…)).addYears(…) |
Add a specified number of years to a date/time field. |
|
Day of Month (1-31) |
… .getDate() |
Returns the day of month for the specified date. |
|
Day of Week (0-6) |
… .getDay() |
Returns the zero-based day of the week (0=Sunday, 6=Saturday). |
|
Hour of Day (0-23) |
… .getHours() |
Returns the zero-based hour for the specified date. |
|
Is After |
… .isAfter(…) |
Returns true if the first date occurs after the second date. If a second date is not specified, Now is used. |
|
Is Before |
… .isBefore(…) |
Returns true if the first date occurs before the second date. If a second date is not specified, Now is used. |
|
Is Between |
… .between(…,…) |
Returns true if the specified date is between or equal to the specified start and end dates. |
|
Is Blank |
… == null |
Checks if a reference is to an empty grid cell. It returns true or false. |
|
Is Equal To |
… === … |
Checks if a numeric argument is equal in value to a second numeric argument. If so, it returns true. |
|
Is In Next X |
….inNext(…numberOf…,"…DaysWeeksMonthsOrYears…") |
Returns true if the date occurs within the next specified number of days, weeks, months, or years of the current date. |
|
Is In Previous X |
….inLast(…numberOf…,"…DaysWeeksMonthsOrYears…") |
Returns true if the date occurs within the prior specified number of days, weeks, months, or years of the current date. |
|
Is Not Blank |
… != null |
Checks if a reference is to a populated grid cell. It returns true or false. |
|
Is Not Equal To |
… !== … |
Checks if a numeric argument is not equal in value to a second numeric argument. If so, it returns true. |
|
Is Today |
(…).between(Date.today(), Date.parse("tomorrow")) |
Returns true if date value is todays date. |
|
Is Weekday |
… .isWeekday() |
Returns true if the date is a weekday (Monday-Friday). |
|
Minutes (0-59) |
… .getMinutes() |
Returns the zero-based number of minutes past the hour, for the specified date. |
|
Month (0-11) |
… .getMonth() |
Returns the zero-based month (0=January, 11=December) of the specified date. |
|
Now |
(new Date()) |
Returns the current date and time. |
|
Today |
(Date.today()) |
Returns the current date. |
|
Value |
(new Date(…year…,…month…, …day…,…hour…,…minutes…)) |
Creates a new date with the specified year, month, day, hours and minutes. |
|
Year |
… .getFullYear() |
Returns the year of the specified date. |
For additional information see: https://github.com/datejs/Datejs
Format
|
Function |
Javascript Notation |
Definition |
|---|---|---|
|
As Currency |
kendo.format("{0:c}", …) |
Formats a numeric value as currency with a dollar sign, for example: $1234.56. |
|
As Date |
kendo.format("{0:d}", …) |
Formats a numeric value as a date in the form m/d/yyyy. |
|
As DateTime |
kendo.format("{0:g}", …) |
Formats a numeric value as a date and time in the form M/d/yyyy h:mm tt. |
|
As Decimal |
kendo.format("{0:n}", …) |
Formats a numeric value as a floating-point number, for example: 1234.56. |
|
As Number |
kendo.format("{0:n0}", …) |
Formats a numeric value as an integer, for example: 1234. |
|
As Time |
kendo.format("{0:hh:mm tt}", …) |
Formats a numeric value as time in the form hh:mm tt. |
Logic
|
Function |
Javascript Notation |
Definition |
|---|---|---|
|
And |
… && … |
Checks whether all arguments are true. If so, it returns true. |
|
Group Selected |
(…) |
Logically groups a statement for order of operations. |
|
If |
(…if…) ? (…then…) : (…else…) |
Checks whether a condition is met. It returns one value if true and another value if false. |
|
Is Blank |
… == null |
Checks if a reference is to an empty grid cell. It returns true or false. |
|
Is Equal To |
… === … |
Checks if a numeric argument is equal in value to a second numeric argument. If so, it returns true. |
|
Is Greater Than |
… > … |
Checks if a numeric argument is greater than a second numeric argument. If so, it returns true. |
|
Is Less Than |
… < … |
Checks if a numeric argument is less than a second numeric argument. If so, it returns true. |
|
Is Not Blank |
… != null |
Checks if a reference is to a populated grid cell. It returns true or false. |
|
Is Not Equal To |
… !== … |
Checks if a numeric argument is not equal in value to a second numeric argument. If so, it returns true. |
|
Not |
!(…) |
Checks whether a condition is not met. If so, it returns true. |
|
Or |
… || … |
Checks whether any of the arguments are true. If so, it returns true. If all arguments are false, it returns false. |
Number
|
Function |
Javascript Notation |
Definition |
|---|---|---|
|
Multiply |
… * … |
Multiplies two numeric values. |
|
Add |
… + … |
Adds two numeric values. |
|
Subtract |
… - … |
Subtracts two numeric values. |
|
Divide |
… / … |
Divides two numeric values. |
|
Absolute Value |
Math.abs(…) |
Returns the absolute value of a number (the number without its sign). |
|
Is Blank |
… == null |
Checks if a reference is to an empty grid cell. It returns true or false. |
|
Is Equal To |
… === … |
Checks if a numeric argument is equal in value to a second numeric argument. If so, it returns true. |
|
Is Greater Than |
… > … |
Checks if a numeric argument is greater than a second numeric argument. If so, it returns true. |
|
Is Less Than |
… < … |
Checks if a numeric argument is less than a second numeric argument. If so, it returns true. |
|
Is Not Blank |
… != null |
Checks if a reference is to a grid cell that is populated. It returns true or false. |
|
Is Not Equal To |
… !== … |
Checks if a numeric argument is not equal in value to a second numeric argument. If so, it returns true. |
|
Max |
Math.max(…1…,…2…,…) |
Returns the maximum value in a set of values. |
|
Min |
Math.min(…1…,…2…,…) |
Returns the minimum value in a set of values. |
|
Random (0-1) |
Math.random() |
Returns a random number greater than or equal to 0 and less than 1, evenly distributed. |
|
Round |
Math.round(…) |
Rounds a number to a specified number of digits. |
|
Round Down |
Math.floor(…) |
Rounds a number down, to the nearest integer or to the nearest multiple of significance. |
|
Round Up |
Math.ceil(…) |
Rounds a number up, to the nearest integer or to the nearest multiple of significance. |
|
Exponent |
Math.pow(…base…,…exp…) |
Returns the result of a number raised to a power. |
|
Square Root |
Math.sqrt(…) |
Returns the square root of a number. |
Text
|
Function |
Javascript Notation |
Definition |
|---|---|---|
|
Append |
… + … |
Appends two text strings. |
|
Contains |
(… .indexOf(…) > 0) |
Returns true if a string contains a specified value. |
|
Index Of |
…indexOf(…substring…) |
Returns the index if a string appears in the value, or -1 if the value does not contain the string. |
|
Is Blank |
… == null |
Checks if a reference is to an empty grid cell. It returns true or false. |
|
Is Equal To |
… === … |
Checks if a text string is equal in value to a second text string. If so, it returns true. |
|
Is Not Blank |
… != null |
Checks if a reference is to a grid cell that is populated. It returns true or false. |
|
Is Not Equal To |
… !== … |
Checks if a text string is not equal in value to a second text string. If so, it returns true. |
|
Replace |
… .replace(…find…,…replace…) |
Replaces part of a text string with a different text string. |
|
Substring |
… .substr(…startIndex…,…length…) |
Returns a substring of the value starting at a specified index and with a specified length. |
|
Value |
"…" |
A specified text value. |
Advanced
|
Function |
Javascript Notation |
|---|---|
|
For Each |
Object.each(…list…, function(item){ // Use item }); |
|
Function (required) |
function(){ // comments return …; }() |
|
If |
if (…test…) { …then… } else { …else… } |
|
Regular expression |
/…regex…/.test(…string…) |
|
Variable |
var …x… = …y…; |
