Anakardian
Registered User.
- Local time
- Today, 05:06
- Joined
- Mar 14, 2010
- Messages
- 173
I have been trying to get a count of the vessels we are operating grouped by months.
The data is structured as follows:
VesselID - VesselName - DateInManagement - DateOutManagement
DateInManagement is always filled out with a date.
DateOutManagement is either with a date or null.
What I would like to get is a list for a year as follows:
Month - NumberOfVessels
As starting input I have a date field used as a parameter in other queries that will be used together with this one. The date is the end data and I would like to get data going back a year.
The purpose is to use the number of vessels in further calculations.
The data is structured as follows:
VesselID - VesselName - DateInManagement - DateOutManagement
DateInManagement is always filled out with a date.
DateOutManagement is either with a date or null.
What I would like to get is a list for a year as follows:
Month - NumberOfVessels
As starting input I have a date field used as a parameter in other queries that will be used together with this one. The date is the end data and I would like to get data going back a year.
The purpose is to use the number of vessels in further calculations.