1 Reply Latest reply: Oct 12, 2011 9:51 AM by Sunil Chauhan RSS

    Hey can anyone help me tame this Horrifying Error Please,Would appreciate it.

      Well the script is:

       

        ,Date([date_of_birth],'DD/MM/YYYY') AS date_of_birth

      //    , Date(Date#([date_of_birth],'DD/MM/YYYY'),'DD/MM/YYYY') AS Date_Of_Birth

      //    , age(today(),  Date([date_of_birth],'DD/MM/YYYY')) as Age,

      //    if(age(today(),  Date([date_of_birth],'DD/MM/YYYY')) > 14, 'Under 14') As Age_Group,

      //   

      //     if(Age(today(),  Date([date_of_birth],'DD/MM/YYYY')) <= 4 and age(today(),  Date([Date_Of_Birth],'DD/MM/YYYY')) >= 1, '1 - 4',  

      //     if(Age(today(),  Date([date_of_birth],'DD/MM/YYYY')) <= 9 and age(today(),  Date([Date_Of_Birth],'DD/MM/YYYY')) >= 5, '5 - 9',

      //     if(age(today(),  Date([date_of_birth],'DD/MM/YYYY')) <= 14 and age(today(),  Date([Date_Of_Birth],'DD/MM/YYYY')) >= 10, '10 - 14',

      //     if(age(today(),  Date([date_of_birth],'DD/MM/YYYY')) <= 19 and age(today(),  Date([Date_Of_Birth],'DD/MM/YYYY')) >= 15, '15 - 19',

      //     if(age(today(),  Date([date_of_birth],'DD/MM/YYYY')) <= 24 and age(today(),  Date([Date_Of_Birth],'DD/MM/YYYY')) >= 20, '20 - 24',

      //     if(age(today(),  Date([date_of_birth],'DD/MM/YYYY')) <= 29 and age(today(),  Date([Date_Of_Birth],'DD/MM/YYYY')) >= 25, '25 - 29',

      //     if(age(today(),  Date([date_of_birth],'DD/MM/YYYY')) <= 34 and age(today(),  Date([Date_Of_Birth],'DD/MM/YYYY')) >= 30, '30 - 34',

      //     if(age(today(),  Date([date_of_birth],'DD/MM/YYYY')) <= 39 and age(today(),  Date([Date_Of_Birth],'DD/MM/YYYY')) >= 35, '35 - 39',

      //     if(age(today(),  Date([date_of_birth],'DD/MM/YYYY')) <= 44 and age(today(),  Date([Date_Of_Birth],'DD/MM/YYYY')) >= 40, '40 - 44',

      //     if(age(today(),  Date([date_of_birth],'DD/MM/YYYY')) <= 49 and age(today(),  Date([Date_Of_Birth],'DD/MM/YYYY')) >= 45, '45 - 49',

      //     if(age(today(),  Date([date_of_birth],'DD/MM/YYYY')) <= 54 and age(today(),  Date([Date_Of_Birth],'DD/MM/YYYY')) >= 50, '50 - 54',

      //     if(age(today(),  Date([date_of_birth],'DD/MM/YYYY')) <= 59 and age(today(),  Date([Date_Of_Birth],'DD/MM/YYYY')) >= 55, '55 - 59',

      //     if(age(today(),  Date([date_of_birth],'DD/MM/YYYY')) <= 64 and age(today(),  Date([Date_Of_Birth],'DD/MM/YYYY')) >= 60, '60 - 64',

      //     if(age(today(),  Date([date_of_birth],'DD/MM/YYYY')) <= 69 and age(today(),  Date([Date_Of_Birth],'DD/MM/YYYY')) >= 65, '65 - 69',

      //    // if(age(today(),  Date([date_of_birth],'DD/MM/YYYY')) > 85, 'Over 85',

      //     if(age(today(),  Date([date_of_birth],'DD/MM/YYYY')) <= 74 and age(today(),  Date([Date_Of_Birth],'DD/MM/YYYY')) >= 70, '70 - 74',

      //     if(Age(today(),  Date([date_of_birth],'DD/MM/YYYY')) <= 79 and age(today(),  Date([Date_Of_Birth],'DD/MM/YYYY')) >= 75, '75 - 79',

      //     if(age(today(),  Date([date_of_birth],'DD/MM/YYYY')) <= 84 and age(today(),  Date([Date_Of_Birth],'DD/MM/YYYY')) >= 80, '80 - 84',

      //     if(age(today(),  Date([date_of_birth],'DD/MM/YYYY')) > 84, 'Over 84',

      //    //,Date([date_of_birth],'DD/MM/YYYY') AS date_of_birth

      //

       

      Iv commented everything out as iv tried many different methods,Closest iv gotten is john witherspoon's technique....

      But it doesnt support my age ranges...Would love a response,AS IM GOING NUTS AT THIS VERY MOMENT.

      Thanks CLOVER