Versions Compared

Old Version 53

changes.mady.by.user Vincent Mutambuki

Saved on

compared with

New Version 54

changes.mady.by.user Vincent Mutambuki

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Excerpt
hiddentrue

+ or - durations to your dates.

Requirements:

  • Use Date or Date Time Picker field for the Formula values.Date 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.

Info

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.

Table of Contents
exclude(Requirements|Table of Contents).*

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.

  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.

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


Expand
titleWatch date ± duration formula tutorial video...
Widget Connector
overlayyoutube
_templatecom/atlassian/confluence/extra/widgetconnector/templates/youtube.vm
width889px
urlhttps://www.youtube.com/watch?v=GXEaeLUn2kY
height500px



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.

  3. Select an ending date time field.

  4. Select a result field for the calculation of your formula.

  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. 



Expand
titleWatch date differnce formula tutorial video...
Widget Connector
overlayyoutube
_templatecom/atlassian/confluence/extra/widgetconnector/templates/youtube.vm
width889px
urlhttps://www.youtube.com/watch?v=qM6gLL16H_c&feature=youtu.be
height500px



Excerpt

Info

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 gear icon, and selecting the option "Refresh custom fields". Now the custom fields you've added should be available to use while editing your formulas.


Write into our Support Desk with any questions you may have.