Forum Discussion

DebLeli's avatar
DebLeli
Qrew Trainee
5 years ago

Formula for # of years since inception

I am trying to get # of years & months since inception from today's date.  

//ToDays([Inception Date]- Today()) / 365.25

I end up with a -negative #.​​

------------------------------
[Deb]
------------------------------
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    Can you an example of a date and what the result should look like.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
  • PaulPeterson1's avatar
    PaulPeterson1
    Qrew Assistant Captain
    5 years ago
    You are getting a negative number because the inception date is a smaller value than the current date.  Change your formula to today - inception date

    ------------------------------
    Paul Peterson
    ------------------------------
    • PaulPeterson1's avatar
      PaulPeterson1
      Qrew Assistant Captain
      5 years ago
      You could also make the formula a little cleaner:

      Year(Today()) - Year(inception Date)

      ------------------------------
      Paul Peterson
      ------------------------------