Search Database for Timestamp range
Is it possible to search a timestamp field by a range. I timestamp each item that gets entered into the database and I want to view the item information based on a range of dates for instance.
I'd like to have 3 menus 1 each for (Date,Month,Year) and then set up the search like so:
Start Date: (Date,Month,Year) To End Date: (Date,Month,Year) Search ---> which then goes to a results page like you would get when using the DataAssist Wizard. I've tried using the DataAssist Search Wizard but it gives me Date Range (text field) To: (text field) (mm/dd/yyy) and it doesn't do anything when you click the submit button.