Billing Cycle

[ali_hijazi]

Hello 

we have table for employees

Each employee has a start date

in the company the fiscal year or billing cycle starts each year on May

I want to count the employees of the current billing cycle i.e. those whose start date is between May 2018 - and May 2019
How can I identify a date as within the current billing cycle every year?

[uacg0009]

Hi,
I think you can add a new column in your table,like:
if(month(start_date) < 5,year(start_date) - 1,year(start_date)) as billing_cycle
Please try.
Aiolos Zhao