Skip to main content
Question

Duration formula in months

  • October 11, 2018
  • 0 replies
  • 119 views
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!
    This topic has been closed for replies.

    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.
    • KimberlyGaston
    • Author
    • Registered
    • October 11, 2018
    This was helpful.  Thank you so much!
    • ChristyMcBee
    • Registered
    • April 19, 2019
    How do I create this same formula but showing the last date of the resulting month, instead of first day of month?
    I think you should post a new complete question with an example. I�m not understanding your question.
    Terms & ConditionsAccessibility statement