Nov 20, 2012

Formula Example - Case Days Open

Today's Formula calculates either the number of days a case was open before being closed or the number of days the case has been open since it was created.

This formula uses 3 different functions:
  1. IF(logical_test, value_if_true, value_if_false) - Determines if expressions are true or false. Returns a given value if true and another value if false.
  2. ROUND(number, num_digits) - Returns the nearest number to a number you specify, constraining the new number by a specified number of digits.
  3. NOW() - Returns a date/time representing the current moment.


Here's a Case view that displays two cases, both open and closed, the fields referenced by the above formula and the formula field itself (# of Days Open).