>>lnMonth1 = month(ldStart) >>lnDay1 = day(ldStart) >> >>lnMonth2 = month(ldEnd) >>lnDay2 = day(ldEnd) >> >>if year(ldEnd) > year(ldStart) >> lnDiff = 1 >>else >> lnDiff = 0 >>endif >> >>select * from People where DOB is not null and DOB<> {} and DOB ; >>between date(year(DOB),lnMonth1,lnDay1) and date(year(DOB) + lnDiff, lnMonth2, lnDay2) >>>
PRIVATE test ldStart = DATE() - 7 ldEnd = DATE() SYS(3054,12,'test') lnMonth1 = month(ldStart) lnDay1 = day(ldStart) lnMonth2 = month(ldEnd) lnDay2 = day(ldEnd) if year(ldEnd) > year(ldStart) lnDiff = 1 else lnDiff = 0 endif select dDOB from Patients where dDOB is not null and dDOB<> {} and dDOB ; between date(year(dDOB),lnMonth1,lnDay1) and date(year(dDOB) + lnDiff, lnMonth2, lnDay2) ; ORDER BY dDOB INTO CURSOR curTest nofilter
Using index tag Ddob to rushmore optimize table patients Using index tag Ddob to rushmore optimize table patients Rushmore optimization level for table patients: partialThe result was correct.