|
ADDDAY
|
Adds the specified number of days to the specified date and returns the resulting date.
|
ADDDAY("1999-01-01",100) returns "1999-04-11 00:00:00"
|
|
ADDMONTH
|
Adds the specified number of months to the specified date and returns the resulting date.
|
ADDMONTH("1999-01-01",100) returns "2007-05-01 00:00:00"
|
|
ADDYEAR
|
Adds the specified number of years to the specified date and returns the resulting date.
|
ADDYEAR("1999-01-01",100) returns "2099-01-01 00:00:00"
|
|
AGE
|
Returns the age for the specified birthdate.
|
AGE(Account:Contact:Birthdate)
|
|
AGEON
|
Given a birth date, returns the age on a specified date
|
AGEON(Account:Contact:Birthdate,TODAY()).
|
|
DATEDIFF
|
Returns the number of days between two specified dates. If the first date is greater than the second date, the value is returned as a negative number.
|
DATEDIFF("1900-01-01","2000-01-01") returns 36524
DATEDIFF("2000-01-01","1999-01-01") returns -365
DATEDIFF(Account:Cases:CreatedDate,TODAY()) returns the number of days a case has been open
|
|
EOM
|
For a specified date, returns the date of the last day of the month.
|
EOM(Account:CaseReturns the month of the specified date as an integer. s:CreatedDate)
|
|
MONTH
|
For a specified date, returns the month as an integer (1-12).
|
MONTH("1999-01-11") returns 1
|
|
ROUND
|
Rounds the specified number or expression. By default, results are rounded to two decimal places, but you can specify the desired number of decimal places for the result.
You can also use the UP, DOWN, HALF_UP, HALF_DOWN, HALF_EVEN, CEILING, and FLOOR parameters to refine the rounding results.
|
ROUND(3.1415 * 3) = 9.42
ROUND(3.1415 * 3, 0) = 9
|
|
FLOOR
|
Use with ROUND to specify that the rounding result is rounded down (towards zero) to the nearest integer.
|
ROUND(3.1415, 0, FLOOR) = 3
|
|
UP
|
Use with ROUND to specify that the rounding result is rounded up (away from zero).
|
ROUND(2.572, 2, UP) returns 2.58
|
|
DOWN
|
Use with ROUND to specify that the rounding result is rounded down (towards zero).
|
ROUND(2.572, 2, DOWN) returns 2.57
|
|
HALF_UP
|
Use with ROUND to specify that the rounding result is rounded towards the nearest neighbor (up or down) unless the neighbors are equidistant, in which case it rounds up.
|
ROUND(2.575, 2, HALF_UP) returns 2.58
|
|
HALF_DOWN
|
Use with ROUND to specify that the rounding result is rounded rounded towards the nearest neighbor (up or down) unless the neighbors are equidistant, in which case it rounds down.
|
ROUND(2.575, 2, HALF_DOWN) returns 2.57
|
|
HALF_EVEN
|
Use with ROUND to specify that the rounding result is rounded rounded towards the nearest neighbor (up or down) unless the neighbors are equidistant, in which case it rounds to the nearest even neighbor.
Behaves as for ROUND HALF_UP if the digit to the left of the discarded fraction is odd; behaves as for ROUND HALF_DOWN if it is even.
|
ROUND(2.57, 1, HALF_EVEN) returns 2.6, which is rounded up to the nearest even one-decimal place.
|
|
CEILING
|
Use with ROUND to specify that the rounding result is rounded up (away from zero) to the nearest integer.
|
ROUND(3.1415, 0, CEILING) = 4
|
|
SQRT
|
Calculates the square root of a value.
|
SQRT(12 * 3) returns 6
|
|
TODAY
|
Returns today's date
|
|
|
YEAR
|
Returns the year of the specified date as an integer.
|
YEAR("1999-01-11") returns 1999
|