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!
|
