InfoMaker - conditional formatting using AND

[a***@gmail.com]

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?

Thanks
Adam

[a***@gmail.com]

Post by a***@gmail.com
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?
Thanks
Adam

Figured it out...

if(daysafter(today(),promise_date) < -2 and disposition = 'D', rgb(255,0,0), 0)