Data expressions are used when defining calculated custom data fields in Workfront. They connect existing Workfront fields in statements that generate a new field.

You can use calculated data expressions in the following areas of Workfront:

- In a custom form

For more information about creating calculated custom data fields on custom forms in Workfront, see "Using Calculated Custom Data." - In a calculated custom column in a report, or list, when you use text mode.

For more information about using text mode in reports and views, see "Understanding Text Mode."

Although the syntax for building a calculated custom field is different than that of building a calculated custom column, the data expressions used are the same.

For more information about the syntax you must use in a calculated custom column, see "Understanding Text Mode."

There are a number of expression that can be used in calculated custom fields. The following list defines the available data expressions in Workfront:

Expression | Example | Explanation | Type |
---|---|---|---|

ADDDAYS | ADDDAYS(date, number) | Add number of days to date | Date & Time |

ADDWEEKDAYS | ADDWEEKDAYS(date, number) | Add number of week days to a date |
Date & Time |

ADDMONTHS | ADDMONTHS(date, number) | Add number of months to date |
Date & Time |

ADDYEARS | ADDYEARS(date, number) | Add number of years to date | Date & Time |

CLEARTIME | CLEARTIME(date) | Clears the time portion of a date | Date & Time |

DATE | DATE(string) | Converts a string to a date | Date & Time |

DATEDIFF | DATEDIFF(date1, date2) | Returns the number of days between the two dates, taking into account the start and the end days of the period selected as well as the time stamps on those days. For example, if the start time of the start date is 3 PM, the start day will not be counted as a full day. | Date & Time |

DAYOFMONTH | DAYOFMONTH(date) | Returns the day of month for the given date as a number, between 1 (January) and 12 (December) | Date & Time |

DAYOFWEEK | DAYOFWEEK(date) | Returns the day of week for the given date as a number, between 1 (Sunday) and 7 (Saturday) | Date & Time |

DAYSINMONTH | DAYSINMONTH(date) | Returns the total days in the month of the given date as a number | Date & Time |

DAYSINSPLITWEEK | DAYSINSPLITWEEK(date) | Returns the total week days between the date and the end of the week, or the end of the month, which ever comes first | Date & Time |

DAYSINYEAR | DAYSINYEAR(date) | Returns the total days in the year of the given date as a number | Date & Time |

DMAX | DMAX(date1, date2[, ...]) | Returns the latest date in the list | Date & Time |

DMIN | DMIN(date1, date2[, ...]) | Returns the earliest date in the list | Date & Time |

HOUR | HOUR(date) | Returns the hour of the given date as a number between 0 and 23 | Date & Time |

MINUTE | MINUTE(date) | Returns the minute of the given date as a number | Date & Time |

MONTH | MONTH(date) | Returns the month of the given date as a number | Date & Time |

SECOND | SECOND(date) | Returns the second of the given date as a number | Date & Time |

WEEKDAYDIFF | WEEKDAYDIFF(date1, date2) | Returns the number of week days between two dates, taking into account the start and the end days of the period selected as well as the time stamps on those days. For example, if the start time of the start date is 3 PM, the start day will not be counted as a full day. | Date & Time |

WORKMINUTESDIFF | WORKMINUTESDIFF(date1, date2) | Returns the number of scheduled minutes between the dates according to the default schedule | Date & Time |

YEAR | YEAR(date) | Returns the year of the given date a number | Date & Time |

ABS | ABS(number) | Returns the absolute value of the number | Mathematical |

AVERAGE | AVERAGE(number1, number2[, ...]) | Returns the average of numbers | Mathematical |

CEIL | CEIL(number) | Rounds a number up to the nearest integer | Mathematical |

DIV | DIV(number1, number2[, ...]) | Divides all the numbers in the order provided | Mathematical |

FLOOR | FLOOR(number) | Rounds a number down to the nearest integer | Mathematical |

LN | LN(number) | Returns natural logarithm value of the number | Mathematical |

LOG | LOG(number1, number2) | Returns logarithm value of number2 to the base number1 | Mathematical |

MAX | MAX(item1, item2[, ...]) | Returns the largest item in the list | Mathematical |

MIN | MIN(item1, item2[, ...]) | Returns the smallest item in the list | Mathematical |

NUMBER | NUMBER(string) | Converts a string to a number | Mathematical |

POWER | POWER(number, power) | Returns a number raised to a power | Mathematical |

PROD | PROD(number1, number2[, ....]) | Multiples all the numbers | Mathematical |

ROUND | ROUND(number[, precision]) | Rounds the number up to specified decimals of precision | Mathematical |

SORTASCNUM | SORTASCNUM(number1,number2,...) | Orders the numbers in ascending order. | Mathematical |

SORTDESCNUM | SORTDESCNUM(number1, number2,...) | Orders the numbers in descending order. | Mathematical |

SQRT | SQRT(number) | Returns a square root of a number | Mathematical |

SUB | SUB(number1, number2[, ...]) | Subtracts all numbers in the order provided | Mathematical |

SUM | SUM(number1, number2[, ...]) | Adds all the numbers | Mathematical |

CONCAT | CONCAT(string1, string2) | Concatenates the string | Text |

CONTAINS | CONTAINS(findText, withinText) | Returns true if the findText string is found within the withinText string | Text |

ENCODEURL | ENCODEURL | Escapes any special characters in the string so they an be included in a URL argument | Text |

LEFT | LEFT(string, length) | Returns a specified number of characters from the left side of a string | Text |

LEN | LEN(string) | Returns the length of a string | Text |

LOWER | LOWER(string) | Returns the string in lower case | Text |

REPLACE | REPLACE(string1, string2, string3) | Replaces all occurences of string2 with string3 in string1 | Text |

RIGHT | RIGHT(string, length) | Returns a specified number of characters from the right side of a string | Text |

SEARCH | SEARCH(findText, withinText[, start]) | Returns the index of the first occurence of findText in the string withinText, starting at the given start position, or -1 if th text is not found | Text |

STRING | STRING(number) | Converts a number to a string | Text |

SORTASCSTRING | SORTASCSTRING(string1, string2, ...) | Sorts a list of strings in ascending order. | Text |

SORTDESCSTRING | SORTDESCSTRING(string1, string2, ...) | Sorts a list of strings in descending order. | Text |

SUBSTR | SUBSTR | Return characters of a string based upon the start and end index specified | Text |

TRIM | TRIM(string) | Removes whitespace from the beginning and end of a string | Text |

UPPER | UPPER(string) | Returns a string in upper case | Text |

CASE | CASE(indexNumber, value1, [value2, ...]) | Chooses a value from a list, based on a index number | Text |

IF | IF(condition, trueExpression, falseExpression) | Evaluates the condition parameter and returns the trueExpression if it is true, or the falseExpression if it is false | Text |

IFIN | IFIN(value, value1[, value2...], trueExpression, falseExpression | If value equals one of the value1, value2... then returns the trueExpression, otherwise returns falseExpression. Should have at least 4 parameters | Text |

IN | IN(value, value1[, value2...]) | Returns true if value equals one of the provided value1, value2..., otherwise false | Text |

ISBLANK | ISBLANK(value) | Returns true if the value is null or empty, false otherwise | Text |

Thank you for taking the time to provide feedback. We appreciate and value your contribution to our site. Feedback provided here is regularly reviewed by our Product Documentation team. Please ensure your comments are specific to improving this help article. Any questions or requests outside this help article content should be directed to our Community User Forum or by submitting a ticket to customer support.

Julie WagoPlease provide examples with actual values.