Hi All,
I'm not sure how to put this question however i have requirment from a user and they want to add a new coloum in issue navigator. That new colom is going to use a formula to calculate the time spent on that ticket
Age of ticket= current date()- ACKNOWLEDGED_DATE()
where Age of ticket= new coloum that needs to be added in issue navigator
Current date= System curent date and time
Acknowledge date= cutsom field setup in the project.
e.g
Age of ticket= 05/Mar/2014- 03/Mar/2014
ans is going to be 2 and so Age of ticket should hold the value as 2 and it would be great to have time stamp added also
i used a custom calculate number filed and wrote a formula which calcuates difference among two dates in hours. later i divide the result by 24 to get number of days.
I think the best approach would be to use groovy scripted fields. Please have a look in the provided link i think you will find what you want.
Cheers
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
can any one help on this issue? This is a critical requirement.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.