AnsweredAssumed Answered

Stumped on Database field calculation

Question asked by RCaauwe on Sep 6, 2012
Latest reply on Sep 6, 2012 by philmodjunk

Title

Stumped on Database field calculation

Post

I have this calc in a field in my database.  It works until it gets to the line where the Dues Year changes from 2012 to 2011.  From there on, the field is blank in those records.  I can't figure out why.  Any help would be appreciated.

If(Dues Year="2012"; If(Bill Cycle="1"; "1/15/2013";

If(Dues Year="2012"; If(Bill Cycle="2"; "2/15/2013";

If(Dues Year="2012"; If(Bill Cycle="3"; "3/15/2013";

If(Dues Year="2012"; If(Bill Cycle="4"; "4/15/2013";

If(Dues Year="2012"; If(Bill Cycle="5"; "5/15/2013";

If(Dues Year="2012"; If(Bill Cycle="6"; "6/15/2013";

If(Dues Year="2012"; If(Bill Cycle="7"; "7/15/2013";

If(Dues Year="2012"; If(Bill Cycle="8"; "8/15/2012";

If(Dues Year="2011"; If(Bill Cycle="9"; "9/15/2012";

If(Dues Year="2011"; If(Bill Cycle=10; "10/15/2012";

If(Dues Year="2011"; If(Bill Cycle="11"; "11/15/2012";

If(Dues Year="2011"; If(Bill Cycle="12"; "12/15/2012";

"" ))))))))))))))))))))))))

Outcomes