I have a start and end date saved in a database for a subscription. The subscription can last from 1 hour to 10 days (or more):
Example of data in my database:
CustID StartSub, EndSub
1 01/08/2015 01:00:00 01/08/2015 02:00:00 - This is a 1 hour subscription
2 01/08/2015 05:00:00 04/08/2015 05:00:00 - This is a 3 day subscription
3 01/08/2015 05:00:00 06/08/2015 05:00:00 - This is a 5 day subscription
4 10/08/2015 05:00:00 11/08/2015 05:00:00 - This is a 1 day subscription
What i would like to do is return the dates between the subscriptions when a date is selected in a calendar control. So selecting 01/08/2015 would return
01/08/2015
02/08/2015
03/08/2015
04/08/2015
05/08/2015
06/08/2015
10/08/2015
11/08/2015
Note the dates MISSING since there is no subscription on or during those days.
Selecting 02/08/2015 would return
02/08/2015
03/08/2015
04/08/2015
05/0 ...
Go to the complete details ...