Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
use can use
class(date(([Date_Of_Birth],'DD/MM/YYYY')),5) to skip above code
hope this helps
use can use
class(date(([Date_Of_Birth],'DD/MM/YYYY')),5) to skip above code
hope this helps