In my database I have a query which calculates number of days missed for a delivery the next step I need to take is to find if any of these occur over a two month period and split the period in to days for each seperate month. For example a customer may have stopped from 28-12-01 to 3-1-02 which is two seperate billing months therefore I would need one period to be for 4 days in deceember and 3 days in jan.
Any ideas would be extremley grateful
Any ideas would be extremley grateful
