AnsweredAssumed Answered

Conditional Statement Using Fixed Date Field in the Calculation

Question asked by DLake on Mar 3, 2010
Latest reply on Mar 3, 2010 by comment_1

Title

Conditional Statement Using Fixed Date Field in the Calculation

Post

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.

 

Date: 1-20-2005

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.

Outcomes