Fetch the latest date between 2 custom fields in case they're exist

Gilad Shtern_twfj0y

I'd like to fetch the latest date between 2 custom fields in case they're exist, as followed:

CF1 exit after status "Active"

While, CF2 may or may not exist.

However, script is not working when the CFs is not exist.

I've written the followed script:

 

import com.atlassian.jira.component.ComponentAccessor

import com.atlassian.jira.issue.fields.CustomField

import java.text.SimpleDateFormat

import com.atlassian.jira.issue.Issue

import java.util.Date

def LatestDue = new SimpleDateFormat("d/MMM/yy")

def customFieldManager = ComponentAccessor.getCustomFieldManager()

def cf1 = customFieldManager.getCustomFieldObject(FIELD_ID1)

def cf2 = customFieldManager.getCustomFieldObject(FIELD_ID2)

def DueField = issue.getDueDate()

if(cf1 != null && cf2 != null && issue.getCustomFieldValue(cf2).after(issue.getCustomFieldValue(cf1))){

    return LatestDue = issue.getCustomFieldValue(cf2)

}else if(cf1 != null && cf2 != null && issue.getCustomFieldValue(cf1).after(issue.getCustomFieldValue(cf2))){

    return LatestDue = issue.getCustomFieldValue(cf1)

}else if(cf1 != null){

    return LatestDue = issue.getCustomFieldValue(cf1)

}else{

}

Kindly,

Gilad

Tom Lister_fo1j4e

Hi @Gilad Shtern 

 

What are you intending to return?

 return LatestDue = issue.getCustomFieldValue(cf2)

is saying return the date formatter set equal to a date value which will probably return null

If you want a date string 

return LatestDue.format((Date) issue.getCustomFieldValue(cf2))

the value will need to be cast to a Date. 

You may need to cast to Date for the after function although not so sure without testing that out.

You could also try just using "compare"

issue.getCustomFieldValue(cf2).compareTo(issue.getCustomFieldValue(cf1)) < 0)

DueField doesn't seem to be used here.