Forum Discussion

HansHamm's avatar
HansHamm
Qrew Assistant Captain
2 years ago

Null Date Issue

Had this posted to a different with no response, so I thought I would try here.

The field that I am using is unchecked for Treat blank values as "0".
I have tried: If([Project - Order Fixtures]=null,null,[Start Date]-Days([Project - Order Fixtures]))
and it gives me the Start Date, same thing when I try
If(not IsNull([Project - Order Fixtures]),[Start Date]-Days([Project - Order Fixtures]),null)

Any idea why when the Project - Order Fixtures is blank my resulting formula is not returning blank?

Thanks



------------------------------
Hans Hamm
------------------------------

2 Replies

  • What field type is [Project - Order Fixtures]?

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • HansHamm's avatar
      HansHamm
      Qrew Assistant Captain
      Mark it is a numeric field

      ------------------------------
      Hans Hamm
      ------------------------------