no - I had not tried that.
I just did this - "query by formula" dialog and use [table]Sent_Date =
Date("02/27/17")
I get the same results 45 records, correctly excluding the one record
with the sent date 02/28/17
On Thu, 2 Mar 2017 00:29:35 +0000, Keisuke Miyako via 4D_Tech wrote:
> but did you use the "query by formula" dialog
> and use [table]Sent_Date = Date("02/27/17") as the criteria?
---------------
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing
**********************************************************************
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]
**********************************************************************
