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