Number of weeks calculated(scripted field)

[neeta jain]

Hi Team,

I have implemented one script for calculating Number Of Weeks, see below:

import com.atlassian.jira.component.ComponentAccessor;
import com.atlassian.jira.issue.Issue;
import java.util.Date.*
import static java.lang.Math.*
import java.sql.Timestamp

def customFieldManager = ComponentAccessor.getCustomFieldManager();
def dateFieldObject= customFieldManager.getCustomFieldObject('customfield_18880');

def dateFieldObject2= customFieldManager.getCustomFieldObject('customfield_12110');

if(issue.getCustomFieldValue(dateFieldObject) && issue.getCustomFieldValue(dateFieldObject2)) {
def dateValue= issue.getCustomFieldValue(dateFieldObject) as Date
def dateValue2= issue.getCustomFieldValue(dateFieldObject2) as Date

def diffdate = dateValue - dateValue2
double noofweeks = diffdate/7

double roundNoOfWeeks = Math.round(noofweeks)

int value = (int) roundNoOfWeeks;

return value

}

Now the user need some modification in it,

as

Number Of weeks(Calculated)= Today's date (NOW)- End Date ?

And if End date is reached, then (End date – Start date).

I have tried but not able to get the Today's date from the script.

Kindly please help me out to reach the modifications in the script.

Regards,

Neeta Jain

[Leo]

Hi @neeta jain

You can get current date in script using below snippet

today = new java.sql.Timestamp(new Date().getTime())

using this you can compare today's date with end date and do the calculation

BR,

Leo