Filter Rows - In This Year or Next Year never completing

[pftcg]

Hey all,

Just doing a pretty simple filter on a Date column. Trying to filter the data to be "is in year" "This Year" or "is in year" "Last Year".

After setting that up, the query just keeps going and never finishes. Or at least it still hasn't finished yet.

Anyone else have similar issues? - thanks!

EDIT:

Found a solution, just first go to Custom Filter instead of Year. For whatever erason if you go to Year first and choose This Year and add a second condition for Last Year the query never ends.

[WillT · Accepted solution]

I checked this out in the Query Editor, as we don't have the dynamic Last Year / This Year options in the other windows. I couldn't reproduce the same issue, and the workaround still works if anyone else runs into this.

[meysun]

Are you doing this filter in the Queries window?