Jump to content

Report Date Filter not working.


Will J Douglas
 Share

Recommended Posts

Hi,

 

I've filtering a report to reduce the data return as we've hit the row limit of 10,000.

 

When I apply they filter it doesn't seem to work.

 

This is the filter.   I've tried various combinations of date format (e.g 01/01/2020,  2020/01/01) but it doesn't seem to work.

image.thumb.png.3008881f16b069d9695b4035e4f504ed.png

 

The date I'm getting back still contains requests logged in 2019

 

image.png.3509c0c10448b9accb8e1f0171d6e537.png

 

I've tried using between clause, a greater and less than clause, a like %2020% clause but none seem to be working.

Regards,

Will.

Link to comment
Share on other sites

@Will J Douglas right, the operator precedence issue... https://stackoverflow.com/questions/1241142/sql-logic-operator-precedence-and-and-or

Your report is actually returning all results where team is "Maintenance". Because of how AND/OR precedence works.

First, the team criteria needs to be put in brackets (because of the OR):

team name LIKE 'maintenance team%' OR team name = 'Maintenance (Accomodation)' )

Second, the year for "date less than" is wrong, it needs to be 2021.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...