Age field on task table

[snehalkhare]

Hi All ,

I want to create a field which calculates age of the open tickets on the task table . I want it on Task table so that it can be used to calculate the age of all the tickets - incident , problem ,request etc.

How this can be done ? After creating this field it has to be used for reporting on task table , means all the open tickets -incident , problem ,request etc. ( ages ) can be represented in the report.

Thanks & Regards,

Snehal Khare

[Arpit Desai]

Is there a way we can have aging category (Example, 0-7 days, 8-14 days etc.) for all open incident using a calculated field?

[Carolina Dunlap]

snehalkhare,

Have you tried using the elapsed time from the SLA table? I was able to get the time from task created on open INCs. I think it works with the all the items and tasks.