Adding <= with 'before' and 'after

[Valeria Colome]

Hello Community. 

I have this query;

project = "Platform Integration" AND "Epic Link" in (Enablement, Project-Support, Operate-Support, Initiatives, ICC, Business-Process) AND (status not in (Open, Closed) AND updated <= 2023-06-23 OR status changed to Closed after 2023-06-17 AND status changed to Closed before 2023-06-23) AND status = Closed

I want to add <= before the last to dates but I get an error that says that I need to add quotation on '<=' but if I add it, I still have the mistake. Does anyone know how to fix this?

[Trudy Claspill · Accepted solution]

Hello @Valeria Colome 

Can you show us how you modified the query?

The use of "before" is the equivalent of using "<". You would not use both.

If you want the equivalent of "<=" then you need to set your date one day forward - 2023-06-24. Then the "before" comparison will match all dates before the 24th, including the 23rd and all dates before that.

[Valeria Colome]

Perfect, that worked! I didn't know that before stands for <. 

Thanks Trudy!

[Trudy Claspill]

And "after" is equivalent to ">".

[Trudy Claspill]

If your question has been answered to your satisfaction, please consider marking the Answer as Accepted.