Forum Discussion

CurtisMcHenry's avatar
CurtisMcHenry
Qrew Member
6 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
6 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
6 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
    ------------------------------