Making some progress. I was missing a pair of ( ) around (date + xx). Calc 1 and Calc 2 are working. Still looking for options on the formula for Calc 2
Correction; Calc 1 & 3 are working. Looking for help with Calc 2
Let ( [
today = Get (CurrentDate) ;
age = Year ( today ) - Year ( YourDate ) - ( today < Date ( Month ( YourDate ) ; Day ( YourDate ) ; Year ( today ) ) )
Case ( 2 ≤ age and age < 4 ; YourDate )
I create 3 calcuation fields layer them on top of each other and format them in different colors.
It could be done with one calculation field using the TextColor() function.