Maybe take out the left parenthesis in front of the second IF command?
..."N/A"; If (Date1 > Get(CurrentDate) ;
Nope, still get the error message too many or not enough of either ( or )
Yet when I count i have the same number of each....just assume I have something in the wrong place or more than i need of something
Strike that!! Clearly I must have had a different error last time I tried it because it is working now when I do it without the ( before the second If. Thanks!!!
Nesting the if functions makes this much harder to work with. Use Case instead:
Case ( IsEmpty (Date1 ); "N/A";
Date1 > Get(CurrentDate) ; "Future date";
Age ( Date1 ; Get ( CurrentDate ) ; 3 ) // "Else"
) // Case