Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,368,548
Community Members
 
Community Events
168
Community Groups

Number of weeks calculated(scripted field)

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

1 answer

0 votes
Leo Community Leader Oct 23, 2020

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 

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events