Script need to be modified

[neeta jain]

Hi Team,

I have implemented a script to calculate Number if weeks from start date to end date, 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 I need some modification in it, 

So the current calculation is (Today - Start date), then once reach the End date, the calculation will be (End date - Start date).

So need Number of weeks =  Today's date(system date) -Start Date

and 

If one issue reached to end date then Number of weeks = End Date-Start date.

Kindly please help me to modify this, I am not aware how to get the system date in the script.

Regards,

Neeta Jain

[Ravi Sagar _Sparxsys_]

Hi @neeta jain 

You can can current date/time using this code.

Date dateObj = new Date()
def timestamp = new SimpleDateFormat('dd-MM-yyyy--HH-mm').format(dateObj)

Also please look for scripts on https://library.adaptavist.com/ you will find plenty of examples.

Ravi 

[neeta jain]

Hi Ravi,

After adding above 2 line code, its giving an error that simpledateformat is not available?

Can you please suggest the solution for it.

Regards,

Neeta Jain

[Ravi Sagar _Sparxsys_]

Hi @neeta jain 

You need to add this line on top as well.

import java.text.SimpleDateFormat

Ravi

[neeta jain]

Thanks Ravi.

But when i return the value for timestamp, it just giving 14(today's date)

I wanted to apply formula for system date - end date.

So how would I get the exact date format, so that i can apply the formula.

Regards,

Neeta Jain

[Ravi Sagar _Sparxsys_]

You can modify the format if you want by modifying the argument

'dd-MM-yyyy--HH-mm'

Did you take a look at the example scripts on library? Take a look at this script to understand how to work with dates.