Expand dates to list each month

[Sade]

Ok, so there has to be an easier way to do this.

I have StartDate and EndDate fields and I need to calculate the number of days between those two dates and break it out by each month within the range.

I've started using code, but it seems like there should be an easier way to do this with a simple "make table" build ... please tell me there is.

Thanx

 

[Ron Coderre]

What do you want the end result to look like?

 

[Sade]

I would like to have 2 columns:

if StartDate = 01/30/2011 and EndDate = 02/01/2011 then:

MONTH..........DAYS
Jan, 2011..........2
Feb, 2011..........1