1 Reply Latest reply on Mar 14, 2013 2:33 PM by philmodjunk

    Date to Years Conversion



      Date to Years Conversion


           I have a date field that is a future lease expiration. I'm trying to convert that data to # of years of term remaining. So I'm looking to subtract a future date from the current date and display the answer as a decimal (example: 6.5)

           It's late in the day so I'm looking for help.

        • 1. Re: Date to Years Conversion

               Round ( ( Future Date - Get ( CurrentDate ) ) / 365.25 ; 1 )

               And make sure that this is a field of type calculation, not number with an auto-entered calculation, and be sure to set the storage option to Unstored or the value will not update with the passage of time.