Solved
check null dates
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
------------------------------
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
------------------------------
- Have you tried IsNull([Vendor - WSIB Expiry Date]) ? I believe that is the way to go with dates or really anything that you are checking for null. That will return true if it is null.
