kzupancic of ACE-CRM
10/31/2018 - 1:26 PM

Contact Age Range - Option 1

Creating Groups of Ages

Age Range - 1
content_copyfile_download
IF [Age]>= 81 THEN '81+ years'
ELSEIF [Age]>= 70 AND [Age] <= 50 THEN '50-70 years'
ELSEIF [Age]>= 35 AND  [Age] <= 49 THEN '35-49 years'
ELSEIF [Age]>= 18 AND  [Age] <= 34 THEN '18-34 years'
ELSEIF [Age]>= 1 AND  [Age] <= 17 THEN 'under 17 years'
ELSE 'NA' END