Hello everyone, i'm facing some problems when reloading my script,it took large time to finish it,i guess because of my function in my table [Earned Premium]:
if((if(date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY')>='05/01/2008' and date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY') <= '04/30/2009',2008,if(date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY')>='05/01/2009' and date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY') <= '12/31/2010',2009))
year(date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY')))<=17,'0-17',if((if(date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY')>='05/01/2008' and date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY') <= '04/30/2009',2008,if(date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY')>='05/01/2009' and date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY') <= '12/31/2010',2009))
year(date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY')))>=18 and (if(date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY')>='05/01/2008' and date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY') <= '04/30/2009',2008,if(date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY')>='05/01/2009' and date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY') <= '12/31/2010',2009))
year(date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY')))<=35,'18-35',if((if(date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY')>='05/01/2008' and date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY') <= '04/30/2009',2008,if(date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY')>='05/01/2009' and date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY') <= '12/31/2010',2009))
year(date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY')))>=36 and (if(date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY')>='05/01/2008' and date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY') <= '04/30/2009',2008,if(date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY')>='05/01/2009' and date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY') <= '12/31/2010',2009))
year(date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY')))<=45,'36-45',if((if(date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY')>='05/01/2008' and date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY') <= '04/30/2009',2008,if(date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY')>='05/01/2009' and date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY') <= '12/31/2010',2009))
year(date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY')))>=46 and (if(date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY')>='05/01/2008' and date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY') <= '04/30/2009',2008,if(date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY')>='05/01/2009' and date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY') <= '12/31/2010',2009))
year(date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY')))<=55,'46-55',if((if(date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY')>='05/01/2008' and date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY') <= '04/30/2009',2008,if(date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY')>='05/01/2009' and date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY') <= '12/31/2010',2009))
year(date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY')))>=56 and (if(date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY')>='05/01/2008' and date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY') <= '04/30/2009',2008,if(date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY')>='05/01/2009' and date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY') <= '12/31/2010',2009))
year(date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY')))<=60,'56-60',if((if(date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY')>='05/01/2008' and date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY') <= '04/30/2009',2008,if(date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY')>='05/01/2009' and date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY') <= '12/31/2010',2009))
year(date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY')))>=61 and (year(date(Makedate(right(EFFDATE, 4),if(mid(EFFDATE, 3,3)='JAN',01,if(mid(EFFDATE, 3,3)='FEB',02,if(mid(EFFDATE, 3,3)='MAR',03,if(mid(EFFDATE, 3,3)='APR',04,if(mid(EFFDATE, 3,3)='MAY',05,if(mid(EFFDATE, 3,3)='JUN',06,if(mid(EFFDATE, 3,3)='JUL',07,if(mid(EFFDATE, 3,3)='AUG',08,if(mid(EFFDATE, 3,3)='SEP',09,if(mid(EFFDATE, 3,3)='OCT',10,if(mid(EFFDATE, 3,3)='NOV',11,if(mid(EFFDATE, 3,3)='DEC',12,00)))))))))))),Left(EFFDATE, 2)), 'DD-MM-YYYY')) - year(DOB))<=65,'61-65','66-Above')))))) as [Age Group]
so i added another table using "resident" and my script was: Temp:
LOAD
//the function look up below
RESIDENT [EarnedPremium];
but it didn't work ,itcouldn't find the field <EFFDATE> can anyone help me to solve it.
Thank You in advance.