Conditional Statement Using Fixed Date Field in the Calculation
This seems so simple, but I'm having trouble getting this to work.
I have a fixed date field and want 3 conditional caculation fields that either reflect the date or show nothing at all. I'm on FMP 8, and don't have access to conditional formatting of text color, so I create 3 calcuation fields layer them on top of each other and format them in different colors. Only the calc fields are shown on my print layout, and only one at any time actually shows the date.
Calc 1: If the date is less than 2 years old, show the date, else show blank
Calc 2: If the date is more than 2 years old, but less than 4 years old, show the date, else show blank
Calc 3: If the dates is more than 4 years old, show the date, else show blank.