Forum Discussion

RussellBeaubien's avatar
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...
  • AustinK's avatar
    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.