Duration formula in months

Question

Hello.&nbsp; I am trying to display a duration formula in months.&nbsp;&nbsp;[Revised End Date]-[Original Start Date]We want to see any of records that are greater than 18 months.&nbsp; I see that I can choose Days or Weeks, but I don't see how to display the number of months.&nbsp;&nbsp;Is there an easy way to do this?&nbsp;&nbsp;Thanks!

quickbasecoachd · Answer

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 · Answer

This was helpful.&nbsp; Thank you so much!

christymcbee · Answer

How do I create this same formula but showing the last date of the resulting month, instead of first day of month?

quickbasecoachd · Answer

I think you should post a new complete question with an example. I�m not understanding  your question.

Forum Discussion

Duration formula in months

Related Content

Create a formula duration over 5 years

Duration Formula

Formula Checkbox and Duration

Duration Fields with Pipelines

Formula Assistance