Posted on: 8/5/2015 1:52:55 PM | Views : 734

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 ...