I want to highlight all overdue invoices in my database with conditional formating.

Currently the conditional formating created works but it works for all records. I want it to work for just records with the "P_Status = Complete/invoice"

 

I am thinking I need an if statement inside an if statement but cannot seem to get it to work.

any help appreciated.

Thanks in advance.

What exactly is your condition?

I don't think "P_Status = Complete/invoice" would work because you haven't said what table P_Status is from.

Sorry I should have included that.

Here is what I am currently trying to get to work:

If ( Projects:_Status = "COMPLETE/INVOICED";
If (Get ( CurrentDate ) ≥ Invoices::Date Created+Int ( 30 ); "");"")

 

When I do this all is clear. If I get rid of the first if then my conditional formating works but it works for all records not just the COMPLETE/INVOICED.

 

Hope this makes sense

I'm a bit of a novice, but I thought that separate conditions worked as ORs.

I reckon you'll need to do something like

Projects: _Status = "COMPLETE/INVOICED" AND ( CurrentDate ) ≥ Invoices::Date Created+Int ( 30 ); "");"")

in the same condition.

But.... remember 'm a novice! :-))

How about:

Projects:_Status = "COMPLETE/INVOICED"
and
Get (CurrentDate) ≥ Invoices::Date Created + 30

Note:

1. You don't need to use the If() function here, because there's no "then";  the condition is either true (apply formatting) or false (don't);
2. 30 already is an integer.

Thanks everyone your help was greatly appreciated. All is good and working.

BTW, the two characters “: and p” equals 

To avoid this paste your  Code into the code button =  <> from above.

That's funny - I thought The Missing Man was being humorous!!

  I like that Mike!

 

Another reason for using the Code button when pasting scripts and calculations ... what shows up in people's emails drops everything after a open bracket '[' (or at least it did in calculations).  Many times people use their email as the response they receive and don't come back to the forum to see that what exists on the post is quite different than their email.