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