1 Reply Latest reply: May 15, 2014 9:54 AM by Grant Perkins RSS

    Aging of items

    jordi _

      Hi!

      I am trying to to calculate the aging of open items from a balance sheet. i have a column with the document posting date format "dd/mm/yyyy". i am trying to calculate the number of days that each line item has been open using the formula AGE so I can do the following operation -[document date].

       

      Is any way to do it?

       

      Thanks!

        • Aging of items
          Grant Perkins

          Hi Jordi,

           

          If you are using the AGE function I guess you have Version 8.

           

          A calculated field with something like this formula should do it for you:

           

          AGE(,TODAY(),4)

           

          would give you the number of DAYS for the difference, assuming that your calculated field was set up to be a numeric field.

           

          DATE() will give the current date.

           

          the final parameter (4 in the example) establishes the unit of measure required. Days in this case.

           

          There is more information in the HELP section for the AGE function.

           

          HTH.

           

           

          Grant