RussellBeaubien
6 years agoQrew Cadet
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...
- 6 years agoHave 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.