Our new Appfire Documentation Space is now live!

Take a look here! If you have any questions please email support@appfire.com

Add certain number of minutes/hours/days/weeks/months to a date

Owned by Radhika Vijji. (Unlicensed)
Last updated: Jun 19, 2019
1 min read

Abstract

This code snippet adds a certain number of minutes/hours/days/weeks/months to a Date field.

Logic

Access the date and add the number of minutes/hours/days/weeks/months to it.

Snippet 

{{ <Date field> | dateadd(<Number of units>,"<Unit>") }}

Placeholders

PlaceholderDescriptionExample
<Date Object>Access a date fieldissue.fields.created
<Number of units>
The number of units to be added5
<Unit>is one of "days", "hours", "weeks" or "months" (or their equivalent: "d", "h", "w", "m")days

Examples

The output of the code snippet is a Moment.js date object which you could use to:

  • Set a Date/Date-time picker field - Eg: Set the Due date to issue created plus 1 month in
    • one of the Set Field Value post-functions
    • one of the Transition issue post-functions on the transition screen, if any

    • in the Create issue post-function under Set fields of new issue section

      {{ issue.fields.created | dateadd(1,"m") }}

  • Conditionally execute a post-function or Unlink issues - Eg: Check that the issue has been resolved for more than 10 days

    {{ now > issue.fields.Resolved | dateadd(10,"d") }}
  • Notify the customer that the issue will be resolved in 6 hours from now through the
    • Comment in one of the Comment issue post-functions

    • Subject/HTML body/Text body of Email issue post-function

      Your issue will be resolved on/before {{ now | dateadd(6,"hours") }}

  • Write a JQL search expression in the Link issues to current issue post-function - Eg: Link issues whose "Planned Delivery date" is less than two days

    {{ issue.fields["Planned Delivery Date"] < now | dateadd(2,"d") | date('YYYY-MM-DD') }}

References