DATE(
IF(AND(MONTH( ${CustomModule1.Effective Date}) = 1, DAY( ${CustomModule1.Effective Date}) = 1), (YEAR(${CustomModule1.Effective Date) + ${CustomModule1.Years Committed} ) - 1,(YEAR( ${CustomModule1.Effective Date} ) + ${CustomModule1.Years Committed})),
IF(MONTH(${CustomModule1.Effective Date}) = 1, 12,
IF(DAY(${CustomModule1.Effective Date}) > 1, MONTH(${CustomModule1.Effective Date}), (MONTH(${CustomModule1.Effective Date}) - 1))),
IF(DAY(${CustomModule1.Effective Date}) > 1, (DAY(${CustomModule1.Effective Date}) - 1),
CASE(MONTH(${CustomModule1.Effective Date}),
1, 31,
2, 31,
3, 28,
4, 31,
5, 30,
6, 31,
7, 30,
8, 31,
9, 31,
10, 30,
11, 31,
12, 30, null))
)