I've got a filter set and the data seems to be defying it.
SET filt to &DATEGOOD4 .AND. &CRED

DATEGOOD4="CTOD(DATE_INSP)>=MSTART .AND. CTOD(DATE_INSP) <=MEND .AND. STATUS # 'CA' .AND. DATE_INSP# 'NA'"
CRED="'CC' $ REMARKS or CR_CARD#' '"
mstart=10/01/2002
mend='07/30/2003

The current record I am on shows the following
date_proc =07/10/03
date_insp='NA'
remarks='CC'
status='OPEN'
set exact=off

?&DATEGOOD4 .AND. &CRED evaluates to .T. !!!!!!!!!!!!!!!!!!!!!!!!!
even though date_insp='NA', I can't quite grasp this.