Discussions

 View Only
  • 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,
         "#F54400")
    )

    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

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