I have a date field "Date1". I have a seperate calculation field "Field1Text" which is going to be a difference in the current date and the date in Date1.
But, I'm trying to put a little more in. I want to say if Date1 is empty then "N/A", if Date1 is greater that the current date then "Future Date", then the difference between the Date1 and current date field otherwise.
I have a custom function for age which works great, it's:
Age ( Birth ; theDate ; Format )
So when I tried to create a calculation that was just the if blank show N/A otherwise give me the difference and it worked fine. This was calculation: If ( IsEmpty (Date1 ); "N/A"; Age (Date1 ; Get ( CurrentDate ) ; 3 ))
But when I try to add the extra step if date1 is future date it tells me I left something out. Clearly I've just written it wrong but not sure how.
I have: If ( IsEmpty (Date1 ); "N/A"; (if (Date1 > Get(CurrentDate) ; "Future date"; Age ( Date1 ; Get ( CurrentDate ) ; 3 ))