AnsweredAssumed Answered

calculate Age order by group

Question asked by HelderSantos on Nov 5, 2011
Latest reply on Nov 8, 2011 by philmodjunk

Title

calculate Age order by group

Post

I would like to build a script to let me know the age of my customers by groupping:

 (Group A) all <= 18
 (Group B) from 19 to 29
 (Group C) from 30 to 39
 (Group D) from 40 up

i have table "person" (p_iD, p_name, p_Bdate, calc_age)

Outcomes