Search results for query: *

If the start date was 6/30/2014 and the end date was also 6/30.2014 - the count is 0, not 1. So I am trying to figure out why it is 0 instead of 1. Is it because it is a datetime datatype?

This works except it does not count for 1 day - if the last day of the month in any of the months - it should count as one day. How do I solve for that? Thanks again for the help!

Let me try this.

Thanks again. Yes it covers all months. A start date can occur in any given month and any day. But it won't go over a 3 month span, it would have to have a renewal start date.

Thank you Pete. No they won't always span 3 months, but theoretically it could. They do want a 3 month summary (a summary for each month). At any time the end date could be filled in during that 3 months, or it could stay null. SO would I have to check for the end date to be null in each...

Thanks again its not quite what I am after, I need to list the months (not like month 1 = January). It doesn't matter what month it starts or ends in. But I need to count the days in each month that the record is in but not past the 3 month span. So from the start date - I need to assign...

Thanks for that - that doesn't quite answer it. I need 3 columns 1 Month (count of days in this month), 2 Month (count of days in this month), 3 Month (count of days in this month) So the start month date maybe be January 14 and the end date might be March 1. Using this scenario - Month 1...

Hi - I am stumped. I need to split and count days between a start date and end date. These dates can happen anytime during the month, but I need to split between 3 months. So the start month date maybe be January 14 and the end date might be March 1. Using this scenario - Month 1 would have...