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

Owned by Daniel Barrow
Aug 29, 2023
1 min read

Abstract

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

Logic

Add the number of minutes/hours/days/weeks/months to the date field using Use(TimeCategory) 

Snippet

use (groovy.time.TimeCategory) {
     return <Date Object> + <Number of units>.<Unit>
 }

Placeholders

PlaceholderDescriptionExample
<Date Object>Access the date fieldissue.get("created")
<Number of units>
The number of units to be added5
<Unit>is one of "minutes","hours","days" "weeks" or "months"months

Examples

The output of this code snippet is a Timestamp which you could use in a Groovy expression, for example to:

  • Calculate and display the issue creation plus 5 days in a Calculated Date/Time field

    use (groovy.time.TimeCategory) {
     return issue.get("created") + 5.days
 }

  • Calculate and display the issue Due Date minus 3 months in a Calculated Date/Time field

    use (groovy.time.TimeCategory) {
     return issue.get("duedate") ? issue.get("duedate") - 3.months : null
 }

References