Discussions

Expand all | Collapse all

Duration formula in months

  • 1.  Duration formula in months

    Posted 10-10-2018 21:45
    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!


  • 2.  RE: Duration formula in months

    Posted 10-10-2018 23:40
    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.


  • 3.  RE: Duration formula in months

    Posted 10-11-2018 15:45
    This was helpful.  Thank you so much!


  • 4.  RE: Duration formula in months

    Posted 04-19-2019 17:06
    How do I create this same formula but showing the last date of the resulting month, instead of first day of month?


  • 5.  RE: Duration formula in months

    Posted 04-19-2019 17:21
    I think you should post a new complete question with an example. I�m not understanding your question.