Why am i getting values for the 2008-08 formulae, I do have policies that incepting with 1/1/08 date, please help...thanks.. .see formula below.
Treaty_Year: IIf([Policy Incpt Date]>=#07/01/2007#,IIf([Policy Incpt Date]<=#12/31/2007#,IIf([Bord Yr]=2007,"2007-07",IIf([Policy Incpt Date]>=#07/01/2007#,IIf([Policy Incpt Date]<=#12/31/2007#,IIf([Bord Yr]=2008,"2007-08",IIf([Policy Incpt Date]>=#01/01/2008#,IIf([Policy...