diffQuarters()

returns the number of whole calendar quarters between two dates the result is positive when date2 is after date1 , and negative when date2 is before date1 syntax diffquarters(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 whole quarters between the two dates partial quarters are not counted examples diffquarters('2025 01 01', '2025 12 31') returns 3 because there are 3 full quarters between january 1 and december 31 diffquarters('2025 01 01', '2026 01 01') returns 4 because there are exactly 4 quarters in a full year related carrot docid\ prpri026iiuebphknzw8u returns the number of days between two dates 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