Page Comparison

Requirements:

• Use Date or Date Time Picker field for creating formulas.

• Use Date or Date Time Picker field for the result field of a Date ± Duration formula.

• Use Date Field or Date Time field for the result of a Date Difference formula.

Date ± Duration

Add or subtract a duration to a date field to create a new date.

1. Enter your custom formula name.

2. Select the Date Time field within your project you want to add or subtract. You can also create /wiki/spaces/A2/pages/3284434950 if necessary from this section. These fields can be date or time.

3. Select whether you want to add or subtract the field.

4. Enter the amount by which you want to add or subtract.

   1. eg. 30m, 6h, 2d, etc.

5. Select a result field for the calculation of your formula. You can also create /wiki/spaces/A2/pages/3284434950 if necessary from this section. These fields can be date or time.

6. The "Save Formula" button saves the formula once you are finished editing it.

Date Difference

Calculate the absolute difference between two dates to determine the Duration.

1. Enter your custom formula name.

2. Select a starting date time field. You can also create /wiki/spaces/A2/pages/3284434950 if necessary from this section. These fields can be date or time.

3. Select an ending date time field. You can also create /wiki/spaces/A2/pages/3284434950 if necessary from this section. These fields can be date or time.

4. Select a result field for the calculation of your formula. You can also create /wiki/spaces/A2/pages/3284434950 if necessary from this section. These fields can only be text.

5. The "Save Formula" 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. 

Image Removed