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

Still need help? Contact Us Contact Us