DAYS¶
Description¶
DAYS takes two dates, from either an information or in ISO8601 format, and returns the
difference between them in days.
If you are looking for the difference in weekdays, use the WEEKDAYS operator.
DAYS measures the gap between two dates and ignores which one comes first, so two dates one day apart give 1 and
two identical dates give 0.
DAYS_BETWEEN counts the days covered instead, including both the first and the last day, so the
same two dates one day apart give 2 there.
Example¶
This returns 10, as the difference between 1st January 2022 and 11th January 2022 is ten days.
This operator can also be used in combination with other operators like TODAY or NOW.