Forum Discussion

DawnRene3's avatar
DawnRene3
Qrew Trainee
4 years ago

Formula Checkbox formula not working for to check dates before today

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: ...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
You were close.  The & symbol is use for concatenation, not for boolean AND.

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

This can also be written like this

not [Modifications Finalized Checkbox and [Session Date] < 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. 

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
  • DawnRene3's avatar
    DawnRene3
    Qrew Trainee
    4 years ago
    Thank you SO much Mark! I was so close, lol.

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