1 of 1 people found this helpful
Table::Date < ( Get( CurrentDate) - 30 )
That's IF ( True or False, THEN result one, ELSE result two ).
Okay, I can do that. But what do I put in for "result one" and "result two"?
... however, you need the result of your calculation to be True or False. So, use Johan's example, instead of "If".
It might be educational to know that you could use both the If and Johan's answer together:
If ( Table::Date < ( Get( CurrentDate) - 30 ); 1; 0) or
If ( Table::Date < ( Get( CurrentDate) - 30 ); 0; 1),
depending on what you want to be true or false. Zero is false; non-zero is true.
Perfect, got it! Sorry, new to Conditional formatting. Did not know I could enter WITHOUT an "If" or a "Get" type thing. Much appreciated!
Okay, fun additional tweak: These records are each meetings with individuals. I have multiple meetings with the same individual on separate dates. Can I add something to the statement, or add an additional calculation, so that only the MOST RECENT meeting is looked at for being over 30 days old?
Assume Table::Contact sets the meeting with someone. So I may have 5 separate meetings with teh same person, all with different dates.
In Conditional Formatting you can add several instances.
First can be the one you asked about first and then you just add another for your second wish