I have a table that tracks projects.
The table contains the following fields: ProjectNumber, DateCreated and DateKickedOff.
When a project is "created", the date it was created is entered into the DateCreated field and the DateKickedOff field is left NULL.
When the project is "kicked off", the date it was kicked off is entered into the DateKickedOff field. This can be the same day it was created or days, weeks or months later.
So at any given time, there are a number of projects "created", but not yet "kicked off" - IE. projects "in queue".
Identifying how many projects were "in queue" on a specific day is easy.
select count(*) from projects where Date_Created <= [any_date] and (DateKickedOff is NULL or DateKickedOff > [any_date])
However, what I am looking to do is create a query that will allow me to chart the history of how many projects were "in queue" on the last day of each month for a given time period.
Thank you in advance!!