To get the difference between two date fields in months, use the below formula Formula(Numeric) – Round(({enddate}-{startdate})/365*12)
Tag: date difference
Calculate Date Difference in Saved Search if one of the Date is in Date/Time format
In saved searches, to calculate date difference we just need to use the Formula(Numeric) with formula {datefield ID 1} – {datefield ID 2). But if one of the date fields is in Date/time format, this formula will not work. If date difference can not be calculated by this formula, use the following formulaFormula(Numeric) : ABS(TO_DATE({datefield… Continue reading Calculate Date Difference in Saved Search if one of the Date is in Date/Time format