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('2022-01-01', '2022-01-11')

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.

DAYS('2022-01-01', TODAY())

Last updated