2 Replies Latest reply on Mar 11, 2011 11:31 AM by julieFrith

    Calculating the age of a record.

    julieFrith

      Title

      Calculating the age of a record.

      Post

      Hello all.

      Something which i thought would be simple is beginning to make my head spin. ! 

      All i need to do is for a field to constantly calculate the age of a record (in days).. which i thought would be easy but alas! 

      I have 2 fields: Date and Age of Record. 

      Date is 'auto enter' Creation Date

      Age of Record is a calculation Get (CurrentDate) - Date

      What i really need is for the Age of Record to constantly update. Can anyone help me with how i do this please?

      Thanks
      jules