We are having problem with search by date. I have SEARCH CRITERIA set for: “Between two values”. The search opens before the grid is displayed. Then when I enter 2 dates, the filtered list shows the records that should not be on the list. The problem is with the first field. Another words if I have FROM DATE and TO DATE, the “to date” works fine.
EXAMPPLE
my FROM DATE=04/01/2017 the records with the date of 03/01/2017 still show up (while they should not). I use complex query from 3 relational tables but this should not really change anything because the search is based only on SINGLE column and single table.
I also created another grid App with Quick Search in it and added Date field to the search list but when I search through the date records are not found. The date is stored in MySQL in DATE() format. When I looked it up in phpMyAdmin the date looks like 04-01-2017
Jena