That formula
should do this (but validate the data to make sure).
here is the logic:
{?date} in {EMP_MAST.GLB_STDT} to
(if {EMP_MAST.TERMDATE}=Date (1899,12,31) then currentdate else {EMP_MAST.GLB_STDT})
the RED part uses either the existing temdate or todays date if they are still working (12/31/1899).
Then the other part just used the parameter date to see if it falls anywhere between each person hire date and 'term date'. If it does then include them in the report.
Hope that helps explain the process I was using 
Edited by DBlank - 11 Aug 2010 at 11:08am
IP Logged