I've got a curious problem that I don't know what the issue is. I have 2 tables that are related (old_dtl + shp_hdr), one of which has a date field.
I have one layout based on shp_hdr and includes the date field from that table. When I go into find mode and search by date (e.g. 7/2017), the results are as expected.
I have another layout that is based on the old_dtl table and shows the date field from shp_hdr. In this case when I go into find mode and search by date, the results include dates that it should not.
Here are a some screen shots to show you what I mean. In both cases I searched for everything in the month of July 2017, and sorted the results by that date field in ascending order.
Any help would be appreciated.