I have a table that contains jobs from 1st Jan 2104 up until today.
I have been asked to supply the number of jobs that where outstanding at the end of each month from Jan 2014 to March 2015.
The Jobs Table is as follows:
JobID
Status (either open or closed)
DateCreated
DateClosed
So if I have the following jobs
ID Status DateCreated DateClosed
1 closed 2014-01-15 2014-01-28
2 open 2014-01-26
3 closed 2014-01-27 2014-03-15
4 closed 2014-02-16 2014-03-21
5 closed 2014-02-18 2014-04-22
I would expect the following at the end of each month
Jan 2014 outstanding = 2 (Jobs 2 & 3)
Feb 2014 outstanding = 4 (Jobs 2, 3, 4 & 5)
Mar 2014 outstanding = 2 (Jobs 2 & 5)
Apr 2014 outstanding = 1 (Job 2)
Cheers
Adrian