>>WHERE Empmaster.deptcd == ?cDept AND INLIST(Empmaster.termdate, {}, DATE())
>>
>>or
>>
>>WHERE Empmaster.deptcd == ?cDept AND Empmaster.termdate IN ( {}, DATE() )
>>
>>The {} means empty date
>
>That won't work Mark... he needs Empmaster.termdate > DATE()
I caught that right after posting, and posted a supplemental reply to that affect.
Mark McCasland
Midlothian, TX USA