Inequality Filters on a date and a number Thanks for the answer. The issue is I need to "get all the item_names which have been shipped more than x_items and manufactured greater than some_date". Even if I split the date into day, month and year, I will not get all the records using normal equalities for day, month and year.