selection set with dates on diff fields don't work

Jay R. Ashworth jra at baylink.com
Wed May 26 10:31:34 PDT 2004


On Wed, Apr 21, 2004 at 04:11:42PM -0400, 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?

Well, my snap reaction is "if you're using letters in your selset, use
them on *all* lines, and write a selection sentence", but that's
probably just because I can't ever remember the rules properly.

You might try that, though, and see what happens.

Cheers,
-- jra
-- 
Jay R. Ashworth                                                jra at baylink.com
Member of the Technical Staff     Baylink                             RFC 2100
The Suncoast Freenet         The Things I Think
Tampa Bay, Florida        http://baylink.pitas.com             +1 727 647 1274

        "They had engineers in my day, too."  -- Perry Vance Nelson


More information about the Filepro-list mailing list