kmacstuf

find by date

Discussion created by kmacstuf on Aug 23, 2017
Latest reply on Aug 28, 2017 by ninja

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.

 

Screen Shot 2017-08-23 at 3.39.09 PM.png

Screen Shot 2017-08-23 at 3.39.35 PM.png

Screen Shot 2017-08-23 at 3.39.59 PM.png

Screen Shot 2017-08-23 at 3.40.21 PM.png

Outcomes