Behavior script to compare three date fields

Vineela Durbha July 10, 2017

Hi I have three date fields and I would like to compare them.
There is some issue with conversion and it is not working as expected.
Can you help me on this

1 answer

0 votes
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 10, 2017

You'll need to explain what you are trying to do and what you've got so far.

Vineela Durbha July 10, 2017

I was trying to compare two date time custom fields using behavior as below.

 

import com.onresolve.jira.groovy.user.FieldBehaviours
import com.onresolve.jira.groovy.user.FormField
import com.atlassian.jira.config.ConstantsManager
import com.atlassian.jira.component.ComponentAccessor
import java.sql.Timestamp
import java.text.SimpleDateFormat
com.atlassian.jira.issue.issuetype.IssueType
import org.joda.time.DateTime
import org.joda.time.format.DateTimeFormat
import org.joda.time.format.DateTimeFormatter
import java.util.Date;
import java.text.DateFormat;
import java.text.SimpleDateFormat;

FormField GAField = getFieldByName("Planned General Availability Date")
FormField RCdate = getFieldByName("Planned RC Date")

FormField cl=getFieldByName("Change List #")


String dateGA=GAField.getValue()
String dateRC=RCdate.getValue()

cl.setFormValue(dateGA)

Date newDate1=Date.parse("E MMM dd HH:mm:ss 'CDT' YYYY",dateGA)
Date newDate2=Date.parse("E MMM dd HH:mm:ss 'CDT' YYYY",dateRC)

if(newDate1.before(newDate2))
{
GAField.setError("GA date should be greater tha RC date")
}
else if(newDate1.after(newDate2))
{
GAField.clearError()
}

 But the comparision is not working. I think when i change time it is not working.
Can you check this and let me know if any error in this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events