Expand all | Collapse all

check null dates

Jump to Best Answer
  • 1.  check null dates

    Posted 02-11-2020 11:01
      |   view attached
    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,

    All is working except "=null" lines these are date fields.

    Russell Beaubien

  • 2.  RE: check null dates
    Best Answer

    Posted 02-11-2020 11:09
    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.

  • 3.  RE: check null dates

    Posted 02-11-2020 11:39
    IsNull worked!!
    thank you

    Russell Beaubien

  • 4.  RE: check null dates

    Posted 02-11-2020 11:17


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