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
------------------------------
Question
Formula Checkbox formula not working for to check dates before today
+5This topic has been closed for replies.
+24You 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
------------------------------
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
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.