I want to create one UDT for range for handling below condition.
When BIRTHDATE < '1946-01-01' THEN 'Traditionalist'
• When BIRTHDATE between '1946-01-01' AND '1964-12-31' THEN 'Boomer'
• When BIRTHDATE between '1965-01-01' AND '1980-12-31' THEN 'Gen X'
• When BIRTHDATE between '1981-01-01' AND '1996-12-31' THEN ‘Millennial'
• When BIRTHDATE between '1997-01-01' AND '2012-12-31' THEN 'Gen Z'
• When BIRTHDATE between '2013-01-01' AND '2025-12-31' THEN 'Gen Alpha'
• When BIRTHDATE between '2026-01-01' AND '2039-12-31' THEN 'Gen Beta’
so how to create UDT and Handle this in Fast Formula If anyone came across this requirement, how to handle this?
Tagged:
0