1 Reply Latest reply on Feb 1, 2019 8:07 AM by Mohsin Esa

    Ticket Aging Calculation

    Mohsin Esa

      I will try to rephrase my question:

       

      I am working on a ticket aging project wherein i have to create a view of ticket aging by different ages, ie.  i have an end date (cut off date) which is static. the aging is counted from the created date (of the ticket) to the (end date ie. static date) where in it has to count and display number of days from the creation date to  the cut off date in different steps. (0-2 weeks, 2-4 weeks, 1-3 months) and so on.

       

      can anyone help me as i am stuck at this point

       

      (Sorry cant attach the worksheet as this is a real company project and confidentiality is to be maintained)

       

      ______________________________________________________________

      I am working on a ticket aging project wherein i have to create a view of ticket aging by different ages. i have an end date which has to be used as bench mark. the aging should go back as 1-2 weeks, 1 month, 3 months, 6 months, 1 year, 2 year so on.

       

      can anyone help me as i am stuck at this point