Forum Discussion

RussellBeaubien's avatar
RussellBeaubien
Qrew Cadet
5 years ago

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
------------------------------
Formulas and functions
  • AustinK's avatar
    AustinK
    5 years ago
    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.
  • AustinK's avatar
    AustinK
    Qrew Commander
    5 years ago
    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.
    • RussellBeaubien's avatar
      RussellBeaubien
      Qrew Cadet
      5 years ago
      IsNull worked!!
      thank you

      ------------------------------
      Russell Beaubien
      ------------------------------
  • DonLarson's avatar
    DonLarson
    Qrew Elite
    5 years ago

    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
    ------------------------------