Aging days- Exclude weekend calculation

vinothkumar
Tera Guru

‎05-19-2015 07:58 PM

Hi,

We have created a custom application and that was went live before three months. Now we need to calculate the aging days[from opened days to till now] for the ticket that needs to exclude weekend.

I tried by scheduled job without excluding weekend and it is working fine

I have created a new field named aging days and can any one help me how can we achieve this by excluding weekend?

Thanks!!

0 Helpfuls
  • 2,064 Views
3 REPLIES 3

vinothkumar
Tera Guru
In response to Gurpreet07

‎05-21-2015 10:46 PM

Hi Gupreet,



Thanks for your response. It means we have to write a schedule job that will execute once in a day, it will update the aging days field.



what would happen for the previously created ticket. I mean the ticket that was opened before the execution of this scheduled job change. Is there any other way?


0 Helpfuls

Gurpreet07
Mega Sage
In response to vinothkumar

‎05-21-2015 11:18 PM

For previously created tickets you could execute a background script utilizing the same type of logic.


0 Helpfuls