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.
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."