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…; |