Re: v12 - Query problem

2017-03-02 Thread Chip Scheide via 4D_Tech
HOLY #%^(

Re: v12 - Query problem

2017-03-01 Thread Keisuke Miyako via 4D_Tech
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

Re: v12 - Query problem

2017-03-01 Thread Kirk Brooks via 4D_Tech
Chip, I'm generally a big fan of writing really lean code but in a case like this I'd put the date value into a variable first. If it still gives inconsistent results I'd do go to the user mode and call up the IP user set, the one that gives you all 46 records. Do apply to selection and set the

v12 - Query problem

2017-03-01 Thread Chip Scheide via 4D_Tech
I have a query being run Query([table];$Query_Field-> = Date(s_Search_Start)) $Query Field is [table]Sent_Date (a date field) s_Search_Start = "02/27/17" If I run the query (in code) the result is 46 records. In debugger Creating an interprocess set, and using the set in the 'user