Filter | Value of x | Notes |
is on or before | - | Any dates on or before 31st Dec 2024 at 11pm would pass the filter |
is before | - | Any dates before 31st Dec 2024 at 11pm would pass the filter |
is on or after | - | Any dates on or after 31st Dec 2024 at 11pm would pass the filter |
is after | - | Any dates after 31st Dec 2024 at 11pm would pass the filter |
is x days before or after | 3 | Any dates on or after 28th Dec 2024 at 11pm AND on or before 3rd Jan 2025 at 11pm would pass the filter |
is x days before | 3 | Any dates after 28th Dec 2024 at 11pm AND before 31st Dec 2024 at 11pm would pass the filter |
is x days after | 3 | Any dates after 31st Dec 2024 at 11pm AND before 3rd Jan 2025 at 11pm would pass the filter |
is more than x days before | 3 | Any dates before 28th Dec 2024 would pass the filter |
is more than x days after | 3 | Any dates after 3rd Jan 2025 would pass the filter |
Day x of last month | 31 | Only 30th Nov 2024 would pass the filter (only 30 days in Nov so it goes to the last day of the month) |
Day x of this month | 15 | Only 15th Dec 2024 would pass the filter |
Day x of next month | 31 | Only 31st Jan 2025 would pass the filter |