Challenge #39: Troubleshoot a Broken Macro

[Waynemk]

and another

[dsmdavid]

May have gotten distracted and reworked the macro instead of fixing it :-S

Spoiler

also, I had troubles understanding the wording:

For example, for June 2013, the denominator would be the total number of accounts open between June 1, 2011 and May 31, 2013. The numerator will be total number of accounts closed in June 2013 or between June 1, 2013 and June 30, 2013. 

But it seems they are using as numerator the accounts closed in June 2013 and open before June 2013

Spoiler

So, instead of:

DateTimeYear([Month]) = DateTimeYear([Close_Date]) AND DateTimeMonth([Month]) = DateTimeMonth([Close_Date])

This:

DateTimeYear([Month]) = DateTimeYear([Close_Date]) AND DateTimeMonth([Month]) = DateTimeMonth([Close_Date])  AND [Open_Date]<[Month] 

[JosephSerpis]

Challenge Completed

[CHarrison]

This turned out to be more fiddly than I expected! 

[asabau]

Got it!

[maxjohnson02]

It took me wayyyy too long to figure out the issue with the Append tool Warn/Error setting, but I finally got there.

[daniel_ferreira]

Follow my solution package attached...

[KOBoyle]

Solution attached.

[justynam]

My solution

[Laurap1228]

This was a fun one!

Pic of my fixed up Macro:

Spoiler