Formula Checkbox formula not working for to check dates before today

Question

I am trying to create a formula checkbox for if a checkbox field is not checked and a date field is before today, check this box. It is not working and I can't figure out why. This is what I have:

If([Modifications Finalized Checkbox],false & [Session Date]<Today(),true, false)

It is telling me that I cannot use '<' because that cannot be used on type text and date. Session Date is a formula date field: ToDate([session_start_time])

Can anyone assist?

------------------------------
Dawn Rene
------------------------------

markshnier__you · Answer

You were close.&nbsp; The &amp; symbol is use for concatenation, not for boolean AND.If([Modifications Finalized Checkbox = false and [Session Date] &lt; Today(), true, false)This can also be written like thisnot [Modifications Finalized Checkbox and [Session Date] &lt; Today().... Because since the result is a boolean checkbox you can just make a statement and then Quickbase will evaluate if it is true or not.&nbsp;------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

dawnrene3 · Answer

Thank you SO much Mark! I was so close, lol.------------------------------Dawn Rene------------------------------

Forum Discussion

Formula Checkbox formula not working for to check dates before today

2 Replies