All active employees in a date range

If you need a list of employees in a specific date range, follow the steps below to retrieve that information:

Open your report, and select Database, and then Select Expert from the toolbar. Choose the first field, p_orighire. Once you do, you should be able to click the show formula button and paste in the following expression.

{hrpersnl.p_orighire} <= Date (2002, 12, 31) and

({hrpersnl.p_active} = "A" or

({hrpersnl.p_active} ="T" and

{hrpersnl.p_termdate} >= Date (2002, 01, 01)))

This will provide a snapshot of your data for a date range. If you need it for a specific date, use the same date in line 1 and line 4 of your expression

To get the most from your Abra HRMS, contact us today!