Forum Discussion

DawnRene3's avatar
DawnRene3
Qrew Trainee
3 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:

    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
------------------------------
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 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
      3 years ago
      Thank you SO much Mark! I was so close, lol.

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