Getting Started

 View Only
  • 1.  Null Date Issue

    Posted 11-02-2022 12:19
    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.  RE: Null Date Issue

    Posted 11-02-2022 13:30
    What field type is [Project - Order Fixtures]?

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Null Date Issue

    Posted 11-02-2022 14:29
    Mark it is a numeric field

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