Challenge #39: Troubleshoot a Broken Macro

[Bobbyt23]

Macro fixing is fun.

[Alteralex]

Spoiler

[mshishido]

ez

[AlexMcData]

Spoiler

 
Good challenge. Most challenging part was the nuances with allowing all appends past 16 records, in addition to ensuring name and formula consistency. 

  

[fluteman]

You had to re-arrange the source inputs, update the date transformation functions, update fields. the rest was straightforward!

[hononno8719]

Spoiler

[Neffarious23]

Good one to get the thought process started

[cmoussa]

[Dhrish]

Hi @AlexMcData,

I guess you missed the 2yrs clause. In the 1st Formula tool you need to rectify the years to be 2 instead of 6.

[Dhrish]

Solution