Duration formula in months

  • 1
  • 1
  • Question
  • Updated 1 month ago
  • In Progress
Hello.  I am trying to display a duration formula in months.  
[Revised End Date]-[Original Start Date]
We want to see any of records that are greater than 18 months.  I see that I can choose Days or Weeks, but I don't see how to display the number of months.  
Is there an easy way to do this?  
Thanks!
Photo of Kim Gaston

Kim Gaston

  • 160 Points 100 badge 2x thumb
  • unsure

Posted 1 month ago

  • 1
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,166 Points 50k badge 2x thumb
Well, not all months are the same length, so it’s hard to say how long a month is.

However,

You can make a formula date field called

Original Start Date Plus 18 Months

with a formula of

AdjustMonth([Original Start Date], 18) will be 18 months after that start date.

So you could use that in a report filter.

If you really want a formula to calculate the difference in months, that is a more difficult formula.
Photo of Kim Gaston

Kim Gaston

  • 160 Points 100 badge 2x thumb
This was helpful.  Thank you so much!