You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I have two date/time fields ("Actual Start" & "Actual End"). Want I want to do is have a scripted field which is the time difference between these 2 dates / time.
So far I've only been able to get an integer response which is representing the days but I need this displayed in minutes / hours etc.
Any help would be appreciated as I’m stuck :(
It's not written for your exact situation, but this script should return a calculated 'Date' value:
def customFieldManager = ComponentAccessor.getCustomFieldManager();
def dateFieldObject= customFieldManager.getCustomFieldObjectByName(
def dateFieldObject2= customFieldManager.getCustomFieldObjectByName(
(issue.getCustomFieldValue(dateFieldObject) && issue.getCustomFieldValue(dateFieldObject2))
def dateValue= issue.getCustomFieldValue(dateFieldObject) as Date
def dateValue2= issue.getCustomFieldValue(dateFieldObject2) as Date
dateValue - dateValue2
Let me know if you had something else in mind, or if you need help getting it to work for your exact situation. :)
You can get the number of milliseconds by doing:
dateValue.getTime() - dateValue2.getTime()
And then convert to hours and minutes from there.
I didn't know the epoch time was in milliseconds, I was getting this value but didn't realise it was milliseconds.
I have converted this using the link below and I know get the required breakdown of the time difference.