Date Formulas
- Vincent Mutambuki
- Tumaini Kioko
- Victor Mutambuki
Add or subtract durations to and from your dates.
Requirements:
If selecting a Date Picker field for use in a Date & Duration formula, the result field of the formula must also be a Date Picker field. Same for the Start Date and End Date of a Date Difference formula.
If selecting a Date Time Picker field for use in a Date & Duration formula, the result field of the formula must also be a Date Time Picker field. Same for the Start Date and End Date of a Date Difference formula.
Use Text Field for the result field of a Date Difference Formula.
Note that calculations for date formulas are affected by your working days configuration. Ensure that your working days are configured appropriately otherwise you calculations might not work correctly.
Date & Duration
Add or subtract a duration to a date field to create a new date.
Enter your custom formula name. (It will be titled 'Date & Duration' by default.)
Select the Date field within your project that you want to add a duration to or subtract a duration from. You can also create new fields if necessary from this section. These fields can be Date or Date Time.
Select whether you want to add to or subtract from the field.
Enter the amount by which you want to add or subtract.
eg. 30m, 6h, 2d, etc.
Use the '@' symbol to reference a custom field of type text, or a system field of type duration (Time Spent, etc.)
Select a result field for the calculation of your formula. You can also create new fields if necessary from this section. These fields can be Date or Date Time.
The "Save" button saves the formula once you are finished editing it.
Date Difference
Calculate the absolute difference in duration between two dates.
Enter your custom formula name. (It will be ‘Date Difference’ by default.)
Select a starting Date or Date Time field. You can also create new fields if necessary from this section. These fields can be Date or Date Time.
Select an End Date field. If you selected a Date field in the previous step, you will only have the option to select a Date field in this step. The same principle will apply if you selected a Date Time field in the previous step. You can also create new fields if necessary from this section. These fields can be Date or Date Time.
Select a result field for the calculation of your formula. You can also create new fields if necessary from this section. These fields can only be of type text.
The "Save" button saves the formula once you are finished editing it.
To update tickets based on today's date or current date and time, create your formula selecting Today for today's date or Now if you want to include a time element in the calculation.
Missing Fields?
If after adding custom fields you wish to use to the project's Create and Edit Screens, they should be available to be used in the formula as long as they are of a compatible custom field type. If the Custom fields do not appear as options when editing the formula then attempt to refresh the available custom fields by; navigating to the top right of the screen, clicking on the settings slider icon, and selecting the option to "Refresh custom fields". Now the custom fields you've added should be available to use while editing your formulas.
Please write to our Support Desk with any questions you may have.