selection set with dates on diff fields don't work

Kenneth Brody kenbrody at bestweb.net
Wed Apr 21 15:42:33 PDT 2004


Dennis Malen wrote:
> 
> Here's an interesting one. The following is a selection set where records in
> the file should meet the selection criteria but filepro does not select the
> record as meeting that criteria.
> 
>        :  97 : Date Status Changed     ge :   03/21/04
> a      :  2  : Client#                               :   0593
> a      :  2  : Client#                               :   0594
> a      :  2  : Client#                               :   0642
>         :  5  : Date Assigned                ge :   04/04/08
> 
> Field 97 has an edit of mdy/ and filed 5 has an edit of ymd/.
> 
> If fields 97 and 5 are used separately its works fine. When both are used as
> above they select nothing. Am I restricted from using two different date
> selections on two different fields?
[...]

Assuming you have a record whose client# is any of 0593/0594/0642, has
a status changed date of 21-Mar-04 or later, and has an assigned date
of 8-Apr-04 or later, then the above should work.

Can you give examples of actual data that "work" when using either date
field but not when using both?

-- 
+-------------------------+--------------------+-----------------------------+
| Kenneth J. Brody        | www.hvcomputer.com |                             |
| kenbrody at spamcop.net | www.fptech.com     | #include <std_disclaimer.h> |
+-------------------------+--------------------+-----------------------------+




More information about the Filepro-list mailing list