Formula Checkbox field based on a date field

Question

Hi,I am trying to set up a formula checkbox field,&nbsp; I needed it to be checked if there is a date in a corresponding date field, if no date I want it to be unchecked. Here is what I have but it has checked all, date and no date.&nbsp;If ([Epic Agreement Sign Date] = null, false, true)Any help would be appreciated.thank you------------------------------Zana------------------------------

markshnier__you · Answer

Try thisIF(IsNull([Epic Agreement Sign Date]), false, true)Which is the same as thisIF(not IsNull([Epic Agreement Sign Date]), true, false)which is the same as thisIF(not IsNull([Epic Agreement Sign Date]), true)But this is a boolean checkbox field so this is the same as all of the abovenot IsNull([Epic Agreement Sign Date])With a boolean you can simply make a statement and Quickbase will come back with if you are saying something that is true or false.------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

zanaskenderi1 · Answer

thank you so much, that worked, I knew I had the null in the wrong place.------------------------------Zana Skenderi------------------------------

Forum Discussion

Formula Checkbox field based on a date field