Home » People » Product Tips: How to Use ‘Less Than’ and ‘Greater Than’ in the Query Builder

Product Tips: How to Use ‘Less Than’ and ‘Greater Than’ in the Query Builder

by John Crowley

July 27, 2015

When you create custom queries using the Filters and Options tab, you’ll notice you have a few different options to choose from for each filter. Two of these options are: Less Than; and Greater Than. So what can you use these two options for?

Well as you might expect, you can use it for pulling any value that is either ‘less than’ or ‘greater than’ another value – for example, you might want to pull data from between two specific dates.

Let’s explore how to use these filter options by walking through a quick example – I’m going to use the example of trying to find out all Assignments submitted by employees for a specific date range.

1. Hit ‘Queries’ (left hand side)
2. Hit the ‘+’ icon to create a new query
3. In the first column, select the ‘Assignment’ option
4. In the remaining three columns (right hand side), select the data you’d like your report to show (default is First Name, Last Name and Employee ID).

Assignment Date’

5. Hit ‘Next’, and then select the option ‘Assignment Date’, choosing your filters as ‘Greater Than’ and ‘Less Than’, and set your values (note: it will not include the day you have selected – choose the day before/after you wish to generate data for).

Name and Description