Skip to main content
Solved

check null dates

  • February 11, 2020
  • 0 replies
  • 55 views
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
------------------------------

Best answer by AustinK

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.
This topic has been closed for replies.

  • AustinK
  • Registered
  • Answer
  • February 11, 2020
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.
Forum|alt.badge.img+15
  • DonLarson
  • Registered
  • February 11, 2020

Russell,

What type of fields are

[Insurance Expires in]
[Vendor - Insurance Expiry Date]

If you calculating durations between dates then you have test them against a duration

[Insurance Expires in]<=Days(2)
 
If they are Numeric fields, then ignore this.



------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
Terms & ConditionsAccessibility statement