Expired license count

[girish2195]

Hi All,

I have license data of an inspector in which Inspector_ID, Activation_date, Expiry_Date and other fields. Once the license is expired, they may issue new license for the same inspector. So the Inspector_IDs are not unique. How do i get to know the number of inspectors whose license is expired for selected period.

Eg:

ID  ActDate    ExpDate

1   1 Jan 18    3 Mar 18

2   2 Jan 18   10 Mar 18

3   4 Apr 18   10 Dec 18

1   4 Mar 18    12 Dec 18

if the selected period is Jun 2018, Result should be 1 (ID = 2)

Please do help asap.

Thanks,

Girish.