but did you use the "query by formula" dialog
and use [table]Sent_Date = Date("02/27/17") as the criteria?it might we worth creating a new DB with just one date field and see if the results are reproducible. then upgrade to a higher version and compare results. 2017/03/02 7:44、Chip Scheide via 4D_Tech <[email protected]<mailto:[email protected]>> のメール： If I run the query editor in the 'user environment', I get 45 records, and the above reference record with a date of 2/28/17 is (correctly) not found. ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
