Field Overview

With the addition of Fixed Date Calculations Fields in Risk Cloud, users can calculate the number of days between two Date Fields. All of the following Fields can be used in a Date Calculation:

Custom Date Picker Fields
Global Date Picker Fields
The following System Fields:

Due Date
Created Date
Completed Date
Last Completed Date

Like other Field types, you can add a Fixed Date Calculation Field to a Workflow Step to display data to end users. To create a Fixed Date Calculation Field, fill out the Name, Label, optional Help Text, and Tooltip as you would any other Field. Additionally, you'll need to select two "Date Fields" you would like to use in the Calculation.

The output of all Fixed Date Calculations will be in a number of days. The order of the "Date Fields" you use in the calculation inputs affects whether the calculation result will be positive or negative. If the expected output is a positive number of days, the first Date Field should be further from the current date and the second date closer to the current date. In the example pictured below, you can calculate how long a record was open by utilizing the Completed Date and Created Date system fields.

If the Completed Date was January 17th, 2023, and the Created Date was January 10th, 2023, then the output of this date calculation will be positive 7 days, meaning the record was opened and closed within that time.

You can find more information on how Date Calculations are calculated in Advanced Date Calculation Fields.

Common Use Cases

Record Completion Time: Calculate how long it took for a record to complete. Create the Date Calculation:
- Completed Date MINUS Created Date

Overdue or Early Records: Calculate how early or late users complete their work. Create the Date Calculation:
- Due Date MINUS Completed Date
Term of Contract: Use custom Date Picker Fields in a Date Calculation to measure the term of particular contracts. Create the Date Calculation:
- Contract End Date MINUS Contract Start Date
Other: For specific risks, issues, or other entities, calculate how long it took for the entity to be received, recorded, reviewed, responded to, remediated, etc., using custom Date Picker Fields.
- For example, to calculate how long it took for a risk to be remediated since identification, create the Date Calculation:
  - Risk Remediated Date MINUS Risk Identified Date

Additional Date Calculation Functionality

Field Variables in Jobs Messages

You can configure Fixed Date Calculation fields as field variables in messages sent by jobs in Risk Cloud. Insert Fixed Date Calculation field variables just like any other field in email, Slack, and in-app notifications.

Field Inputs to Standard Calculations

The output of a Fixed Date Calculation field (numerical value, not a date) can be used as inputs to standard calculations just like any other field used in standard calculation expressions.

Conditions

You can use custom date calculation fields in section, subsection, and field conditions. Date calculation fields can also be used in conditional edge paths and Job conditions to drive conditional logic in Risk Cloud.

Date Calculation Limitations

Date Calculation Fields cannot be used for the following uses. If you have a use case requiring additional functionalities, please upvote the appropriate Risk Cloud feature requests (FR).

Date Calculations do not currently have the ability:
- to add the Current Date as a "Date Field" input - Feedback Request
- to be added to Visual Reports on the Home Screen -Feedback Request
- to determine a Date Field using another Date Field +/- number of days -Feedback Request
- to determine when the Date Calculation Field is visible to end users - Feedback Request
- to display an output in hours, minutes, and seconds - Feedback Request

Additional Information

For more information on Date Calculation Field settings and options, please look at Advanced Date Calculation Fields.

You may also enjoy our articles on Field Types, Advanced Calculation Fields, and Record Due Jobs.