Flow Filters
Flow has some powerful filters and this article shows the filters available and how they work
DateTime Filters
For the filters below, we will use the comparison date as 31st Dec 2024 23:00:00 (11pm).
| 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 |