Using the PS_Personnel table, how can I select all employees who were active during a time period (ex. Jan 1 2010 - Dec 31 2010). When I select employees hired or rehired before Dec. 31, those terminated after Jan. 1, and those with no termination date, the report excludes rehired employees where a termination date exists in their record.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.