I am trying to create some useful filtering tools for an order list. I have already configured a compound search using a single text search field, and I wanted to also add two date boxes (start and end date) so I could restrict the range of orders shown. The end result should provide me with a search tool that allows me to use my text search as well as optionally specifying a start and end date for the list.

I have already configured the filters in the database connector. Here's how it looks.


I know the filters for the search form field are right because they work. I just can't get any sort of date range filtering to work.

I first tried using DMXzone Calendar 2 extension, and when that didn't work, I tried just regular text fields and manually typing in the dates for those fields.

How do I set up a date range filter with HTML5 Data Bindings?

Hi Steve,

In order to filter by date, you need to return the dates in the same format as they are stored in your database.