Please do as follows to create a query for active employees as of the current month:
Go to Query Setup and click New.
Enter Query Name, e.g. ActiveAsOfThisMth.
Enabled the checkbox Use Custom Query and clicked the 3 dotted button.
Enter the Query, for example, if it is for May 2025 as
Employee.CessationDate = '1899-12-30' OR Employee.CessationDate >= '2025-05-01
You need to change the Cessation date every month to view active employees for the month you want to view. For example, you would change 2025-05-01 to 2025-06-01 in the query above in step 6 if you wanted to view June 2025 data