I have a colour coding formula on my Purchase Order reports.
Before we pay a vendor for the work done on a Purchase Order we need up to date Insurance & WSIB
If([Total Remaining After Payables]<=0,"", //if = 0 the PO has already been paid
If([WSIB Expires in]<=2
or [Insurance Expires in]<=2
or [Vendor - Insurance Expiry Date]=null
or [Vendor - WSIB Expiry Date]=null,
"#F54400")
)
All is working except "=null" lines these are date fields.
------------------------------
Russell Beaubien
------------------------------