diffDays()

returns the number of days between two dates the result is positive when date2 is after date1 , and negative when date2 is before date1 syntax diffdays(date1, date2) parameters parameter type description date1 date docid\ xtaqdzvlbtakjxrnpfwe9 the date from which counting begins date2 date docid\ xtaqdzvlbtakjxrnpfwe9 the date at which counting ends return type number docid\ uci5tctfvbhonej6zqijg the number of days between the two dates examples diffdays('2025 01 01', '2025 12 31') returns 364 diffdays('2025 03 15', '2025 01 01') returns 73 because date2 is before date1 related carrot diffweeks() docid\ hugmmhjqhzbnhoh3njtfy returns the number of whole weeks between two dates diffmonths() docid\ jo2ubeint1mtnw1xnl7 2 returns the number of whole months between two dates diffyears() docid\ xtagbzq7ngaiktsg0paom returns the number of whole years between two dates