A filter can be created using Relative or Absolute dates.
​

For example you may want to know all the accounts who have expected payment dates during October, so you would use the filters after 31/09/2021 and before 01/11/2021.
​

For example the coming week will always be from "today" and "7 days in the future".

If you want to create filters for dates in the future, you need to use negative numbers. For example, accounts who have an expected payment date in the next week, need to use the filter expected payment date more than -7 days ago.

Then, to ensure the filter excludes any expected payment dates from the past.
Add another field to the filter using the term less than 0 days ago.

Invoices due to be paid in the coming week (7 days)

​

Filters for “less than X days ago” will also apply to dates in the future. If you’re filtering on an attribute that can be a past or future date, add a filter for “More than 0 days ago” to only target those in the past.

Invoices which were expected to be paid in the last week (7 days)

If you have any trouble get in touch with our Support team.