How to write an expression using date range AND criteria

[pconnole]

Hello,

I am trying to filter out employees who haven't worked at least 88 hours within the fiscal month to be eligible for a bonus program. The fiscal month in reference is 06-04-2023 to 07-01-2023. These are exempt employees (who don't clock in or out) and work 8 hours a day, 5 days a week (not saturday or sunday). The actual last day of leave is recorded when they have returned from leave. If it is null, that means they are still out on the leave.

Any suggestions on what tool and/or expression to write that meet these criteria?

Thanks in advance.

[binu_acs]

@pconnole Can you provide the expected output result?

[KamenRider]

Hi @pconnole 

Can you at least give us a sample solution or screenshot so that we can fully understand your scenario?

Thanks,

Kamen

[pconnole]

Hello,

I am going to delete this request. I cannot post more information as it is confidential in nature. Thanks.