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 docid\ xtaqdzvlbtakjxrnpfwe9 the date from which counting begins date2 docid\ xtaqdzvlbtakjxrnpfwe9 the date at which counting ends return type 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 docid\ hugmmhjqhzbnhoh3njtfy returns the number of whole weeks between two dates docid\ jo2ubeint1mtnw1xnl7 2 returns the number of whole months between two dates docid\ xtagbzq7ngaiktsg0paom returns the number of whole years between two dates