...
...
...
...
...
...
...
...
Calculations - based on Date Fields
Calculations can now be performed with date fields.
We support these types of calculations
Calculation
Result Displays as
Explanation
Calculation
Result Displays as
Explanation
...
Date Field + Number field
...
Displays as a date
...
Adds number of days based on the value in the number field to the value in the date field
Eg
1-April-24 + 10 = 11-April-24
...
Date Field - Date FIeld
...
Displays as a number
...
Finds the day difference as a number between 2 dates
...
Date Field + Select field (based on code)
...
Displays as a date
...
Add number of days, months based on the code of the select field. As explained here
...
Date Field - Select field (based on code)
...
Displays as a date
...
Subtracts number of days, months based on the code of a select field.
...
Due date, Issued Date, Modified Date, Date First Closed, Date First Open, Date First Opened
+
Select field (based on code)
...
Displays as a date
...
Same as row 3
Calculations using standard fields do not support setting time values.
...
Due date, Issued Date, Modified Date, Date First Closed, Date First Open, Date First Opened
-
Select field (based on code)
...
Displays as a date
...
Same as row 4
Calculations using standard fields do not support setting time values.
...