Forum Discussion

CurtisMcHenry's avatar
CurtisMcHenry
Qrew Member
5 years ago

Calculating Number of Months and Days between 2 dates?

Hey there, I have two fields [Start Date] and [End Date], where I need to calculate the number of Months and Days between them. For Example: [Start Date] = 08-30-2019 [End Date] = 10-01-...
Formulas and functions
BlancaAnderson's avatar
BlancaAnderson
Qrew Assistant Captain
5 years ago
Were you able to get the formula for this?  I need to calculate the number of months between two dates.

------------------------------
Blanca Anderson
------------------------------
  • BlancaAnderson's avatar
    BlancaAnderson
    Qrew Assistant Captain
    5 years ago
    Answer:  I was using the wrong field type.  I was using duration but needed to use Formula Numeric.  
    This formula worked for me.

    (([End Date] - [Start Date]) / Days(30))

    ------------------------------
    Blanca Anderson
    ------------------------------
    • ParadoxHomes's avatar
      ParadoxHomes
      Qrew Member
      4 years ago
      This formula worked, but sometimes skipped a number for me. I found this formula to work pretty well on an amortization table I was building.

      var number numOfYears = Year([Payment Date]) - Year([First Payment Date]);
      var number numOfMonths = Month([Payment Date]) - Month([First Payment Date]);
      var number npers = If($numOfYears = 0,
      $numOfMonths,
      ($numOfYears*12) + $numOfMonths);
      $npers

      ------------------------------
      Paradox Homes
      ------------------------------