Date filtering after date 1, before date 2 do something

[MartinR]

What are you trying to achieve?

I need to check if a date falls within a quarter (i.e. April-June, July-Sept, Oct-Dec, Jan-March) and do something based on that.

I get today’s date with the (now) function. I’ve done everything I can to parse it. On my filters I have datetime functions of Later or equal to AND Before or equal to and yet my filter for 1/10/25 to 31/12/25 passes. But the date is 22/07/2025 in my variable.

The filter for April - June works.

Steps taken so far

I’ve tried parsing date to remove time, I’ve tried formatting the date to be DD/MM/YYYY rather than MM/DD/YYYY. Double checked that I’m using datetime operators not just time operators.

Screenshots: scenario setup, module configuration, errors

[Prem_Patel]

Heyy @MartinR Welcome to the community!

Can you share your filter configuration screenshot!

Best,
@Prem_Patel

[MartinR]

Hi, so I’ve two filters directly following on from a router - screenshots attached.

To be honest I only need to worry about the month, so I can change the filter to be if the month is 4-5-6 then it’s Q1, if the month is 7-8-9 then it’s Q2 etc.