Discussions

 View Only
  • 1.  How to calculate the number of months between 2 dates

    Posted 04-16-2019 14:57
    Simply, I need a formula to calculate the number of months a vehicle has been in service.  I have a [In Service Date].  So I am thinking something like Today()-[In Service Date]=xxxMonths


  • 2.  RE: How to calculate the number of months between 2 dates



  • 3.  RE: How to calculate the number of months between 2 dates

    Posted 04-16-2019 18:46
    This worked great!  Thank you!


  • 4.  RE: How to calculate the number of months between 2 dates

    Posted 10-28-2019 22:37
    Hey QB Team! I am seeking to do the same, calculate the number of months between a date and (today), looks like this thread addressed it but the URL above & referenced as a great solution is broken (says "Sorry! The page you requested was not found")

    Can anyone share the formula? 

    Tied to this I am trying to look back at my company's sales by channel and get an average per month sales since their first sale, then make another field next to it that shows their sales in the last 30 days so my sales team can see if their account is declining or growing. 

    Thank you !
    Bobby 



    ------------------------------
    Bobby Hollis
    ------------------------------



  • 5.  RE: How to calculate the number of months between 2 dates

    Posted 10-22-2020 15:49
    Is there another location for this link?  I am looking for the same - calculate # of months between two dates.

    Thank you​

    ------------------------------
    Eric Fixler
    ------------------------------



  • 6.  RE: How to calculate the number of months between 2 dates

    Posted 10-22-2020 15:52
    I suggest that you post a new complete question with an example and clarity on the result you are looking for.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 7.  RE: How to calculate the number of months between 2 dates

    Posted 04-16-2019 17:05
    Do you need the answer in whole months? Rounded up or down? Or fractional months? Or months + days?


  • 8.  RE: How to calculate the number of months between 2 dates

    Posted 04-16-2019 18:47
    I would only want to show the whole months.  So if the calculation went into a partial month, I would want it to round up to the next whole number.


  • 9.  RE: How to calculate the number of months between 2 dates

    Posted 04-16-2019 19:25
    Did you get it working based on Mark's formula from the other thread?


  • 10.  RE: How to calculate the number of months between 2 dates

    Posted 04-18-2019 13:03
    Yes, it worked perfectly!