How to calculate Age of the tickets?

[taqdeer]

Hi All,

I want to calculate the age of the incidents on the incident table.

Could some one please help me on starting from creating the Age field and till it calculates the age.

Thanks.

[Prasant Kumar 1]

Hi,

Please follow below screenshots:-

If i was able to solve your query, please mark my answer correct and helpful.

Thanks & Regards

Prasant kumar sahu

[Prasant Kumar 1]

Hi,

please follow Modified Script of Above mentioned Business rule:-

If i was able to solve your query, please mark my answer correct and helpful.

Thanks & Regards

Prasant kumar sahu

[taqdeer]

Hi Prasant,

That was helpful.

But after applying your steps what I noticed is Age of ticket field doesn't display its value on Table list. It is displaying when we open the incident but not on the table list. Attaching the Screenshot for your reference.

[Prasant Kumar 1]

Hi,

Yes it is applied to only form view why because it is using display business rule. which works when form loads into UI.

If i was able to solve your query, please mark my answer correct and helpful.

Thanks & Regards

Prasant kumar sahu

[taqdeer]

But Prasant,

I want to schedule a report which display the age of the ticket in it. So, would it be possible for us to display it on Table list?

Also, When I click on create new ticket by default it is showing as 1814 in the Age of ticket field. Below is the reference.