Skip to main content
Solved

check null dates

  • Feb 11, 2020 4:01 PM UTC
  • 0 replies
  • 84 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.
View original
This topic has been closed for replies.

  • AustinK
  • Qrew Colonel
  • Answer
  • Feb 11, 2020 4:09 PM UTC
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+19
  • DonLarson
  • Qrew Champion
  • Feb 11, 2020 4:17 PM UTC

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