https://community.qlik.com/t5/QlikView/Billing-Cycle/m-p/1525698#M438391 Hi,<BR />I think you can add a new column in your table,like:<BR />if(month(start_date) &lt; 5,year(start_date) - 1,year(start_date)) as billing_cycle<BR />Please try.<BR />Aiolos Zhao Thu, 03 Jan 2019 08:31:43 GMT uacg0009 2019-01-03T08:31:43Z https://community.qlik.com/t5/QlikView/Billing-Cycle/m-p/1525458#M438367 <P>Hello&nbsp;</P><P>we have table for employees</P><P>Each employee has a start date</P><P>in the company the fiscal year or billing cycle starts each year on May</P><P>I want to count the employees of the current billing cycle i.e. those whose start date is between May 2018 - and May 2019<BR />How can I identify a date as within the current billing cycle every year?</P> Wed, 02 Jan 2019 14:07:46 GMT https://community.qlik.com/t5/QlikView/Billing-Cycle/m-p/1525458#M438367 ali_hijazi 2019-01-02T14:07:46Z https://community.qlik.com/t5/QlikView/Billing-Cycle/m-p/1525698#M438391 Hi,<BR />I think you can add a new column in your table,like:<BR />if(month(start_date) &lt; 5,year(start_date) - 1,year(start_date)) as billing_cycle<BR />Please try.<BR />Aiolos Zhao Thu, 03 Jan 2019 08:31:43 GMT https://community.qlik.com/t5/QlikView/Billing-Cycle/m-p/1525698#M438391 uacg0009 2019-01-03T08:31:43Z