cancel
Showing results for 
Search instead for 
Did you mean: 

InfoMaker Conditional Formatting - Multiple Fields in an IF statement

Former Member
0 Kudos

Hi

First time posting to the Group.  Thanks for having this resource available.

I am trying to create a conditional format, turning the font red for a field, I want to test two fields at once for the condition to be true.

IF(dateafter(promise_date,today()) < 2 AND disposition = 'D', rgb(255,0,0),0)

This expression does not pass the Verify test.

How do you test two fields at once using the Conditional Formatting popup?

I could not find any examples in the Manual where multiple fields were tested in Conditional Formatting.

I'm familiar with CASE, can I use an "AND" in a CASE statement?

This works in SQL but not in the Conditional Formatting popup.

Thanks

Adam

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Solved it myself.

Issue wasn't the AND, it was the dateafter().  It was supposed to read daysafter().

AND works fine.

Thanks