Using If condition for Age however not getting result.

[sunil-kumar5]

Hi Community,

I am actually trying to get the age range however only getting result for "50 Plus"

First I added "date((date(today(),'DD/MM/YYYY')-date([DATE_OF_BIRTH],'DD/MM/YYYY')),'YY') as Age," in EE.Mast table and get the Year of age for each candidate.

Then, I applied age range per below and load new table as EMS:

EMS:
Load EMP_CODE,EE.Mast.Age,

If(EE.Mast.Age>10 and EE.Mast.Age<18,'<18',
If(EE.Mast.Age>=18 and EE.Mast.Age<25,'18-25',
If(EE.Mast.Age>=25 and EE.Mast.Age<30,'25-30',
If(EE.Mast.Age>=30 and EE.Mast.Age<40,'30-40',
If(EE.Mast.Age>=40 and EE.Mast.Age<=50,'40-50','Plus 50'))))) as Age_Years Resident EE.Mast;

After loading the data I am only getting "Plus 50" for all records.

Any help in this appreciated:-)

Thanks

[tm_burgers · Accepted solution]

There is a built in script function for Age

Age(today(),[DATE_OF_BIRTH]) as Age

Otherwise I cannot see any errors. 

[sunil-kumar5]

Thanks for your help!! Tm_burgers 

Its working absolutely fine.