Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Behavior script to compare three date fields

Vineela Durbha
Contributor
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-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 10, 2017

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

Vineela Durbha
Contributor
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