Need to get count of employees as of date and as of first day of fiscal year i.e. 01-apr-20XX

Summary

Need to get count of employees as of date and as of first day of fiscal year i.e. 01-apr-20XX

Content

Hi,

 

We have a requirement as below:

===========================

Need to calculate employees (1) as of date and (2) as of first day of fiscal year i.e. 01-apr-20XX(XX is the year in question).

I need to basically count no. of employees for:

(a)  whose assignment_start_date <= current_date (which will be one metrics)

(b) whose assignment_start_date <= (first day of the current financial year, i.e. 01-Apr) (this is second metrics)

 

Now , second metrics is complicated as we need to consider 2 parts of it, one is :- suppose the current_date is say, 22-May-2018, then the first day of this fiscal year is 01-Apr-2018 and so, assignment_start_date should be <= 01-Apr-2018.