Subtracting more than 24 days from a custom field using

David Hogan_ttwcv6

I have a script that works really well to subtract days from a custom field. That is, until I need to subtract more than 24 days.

Here are the details:

customfield_14082 = 2018-09-15 00:00

Subtracting 14 days script returns 2018-09-01 00:00 - PERFECT! Works 1 thru 24 days.

Subtracting  25 (or greater same issue) returns  2018-10-9 17:02 - What? Why?

 

Here is the script:

<!-- Subtracts two weeks from the New Business Date (customfield_14082) - David Hogan 04/06/2018
@Formula:
if (issue.get("customfield_14082") == null)
return null;
long ms = issue.get("customfield_14082").getTime() - 25*24*60*60*1000;
date = new Date(ms);
return date;
-->

 

Any assistance appreciated!

David

 

Tarun Sapra

I presume the script is using the groovy interpreter, and if that's the case then it's very easy to subtract the days and the get the correct answer.

Sample - to subtract 25 days

use (groovy.time.TimeCategory) {
  def date = new Date()
  println date
  println date-25.days
}

https://stackoverflow.com/questions/8816990/subtract-a-date-by-1-or-2-in-groovy

 

And it's super easy in groovy to get date object from the String using Date.parse method

Sample here - http://rmr.wikia.com/wiki/Groovy_Date_Parsing_and_Formatting

Thus, once you have the date object (after converting string format of customField.value()) then you can just subtract the 25 days and that should get you the correct value as that is more idiomatic way of doing things.