Filters

Filter must be typed exactly as seen below. The filter may appear on more than one line on the chart, but type as one line in the software. Substitute the correct amounts, dates, name etc. you are looking for but be sure not to change the filter structure. Be sure to add the period symbol before and after the word "and" in the filter. If the information you are looking for is not listed below, call Tech Support at (303) 741-9031 and we will help you create a filter.

Data to Find: Type Exactly:
APR less than < 400% (FECH+OTCH)/PRCH * 365/(PAYBDATE-LOANDATE+1) * 100 <400
Balance due greater than $0.00 BALADUE>0.00
Balance due greater than $0.00 and contract date is less than or equal to 12/31/98 BALADUE>0.00 .and. loandate<= ctod('12/31/1998')
Balance due greater than $0.00 but $100.00 or less for all contracts written in 1999 LOANDATE>=ctod('01/01/1999') .and. LOANDATE<=ctod('12/31/1999') .and. PRCH>0.00 .and. PRCH<=100.00
Balance due greater than or less than $0.00 BALADUE<>0.00
Balance due greater than or less than $0.00 for store A only BALADUE<>0.00 .and. DEPANUMB='A'
Customer's employed by Coors ENAME='COORS'
Customers that live in Denver CCITY='DENVER'
Date the customer first came in was before 1/1/99 CREATED<ctod('01/01/1999')
Payback date less than 1/1/99 PAYBDATE<ctod('01/01/1999')
Title Loans only with a returned item date of 3/3/99 that have a balance still due of greater than or less than $0.00 TITLPDL='P' .and. RETUDATE<ctod('03/03/1999') .and. BALADUE<>0.00
Title Loans only with a returned item rely by date of 4/2/99 that have a balance still due of greater than or less than $0.00 TITLPDL='T' .and. REPLDATE=ctod('04/02/1999') .and. BALADUE<>0.00
Cash given to customer equals $300.00 on contracts written between 8/31/99 and 8/31/00 PRCH=300.00 .and. LOANDATE>ctod('08/30/1999') .and. LOANDATE<ctod('09/01/2000')
Number of checks deposited between 8/31/99 and 8/31/00 DEPODATE>ctod('08/30/1999') .and. DEPODATE<ctod('09/01/2000')