selection set with dates on diff fields don't work

Dennis Malen dmalen at malen.com
Wed Apr 21 13:11:42 PDT 2004


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?

What am I missing? I'm on 4.8 AIX Unix.

Thanks,
Dennis Malen
516.479.5912



More information about the Filepro-list mailing list