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)
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.