Forum Discussion

AnnettaColeman's avatar
AnnettaColeman
Qrew Cadet
3 years ago

Confused over Null Date Handling

There must be an easy way to populate a formula checkbox when a date field is not null.   Every time I try to use Nz formula I  keep getting errors that it is looking for duration.    Help?

------------------------------
Annetta Coleman
------------------------------

2 Replies

  • AustinK's avatar
    AustinK
    Qrew Commander
    Post your current formula in text and we can help make the changes here.
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      try this

      not IsNull([My Date Field])

      ------------------------------
      Mark Shnier (YQC)
      mark.shnier@gmail.com
      ------------------------------