Not sure what obvious thing I'm missing here, but any help would be awesome!
If ([Current Season Start Date]=null, true, false)
Long story is I'm trying to do this -
If ([Current Season Start Date]=null OR ToDate([Start Date])>=[Current Season Start Date], true, false)
Thank You in advance for the help!
------------------------------
Chris
------------------------------
Question
Formula Checkbox - If Date Field = Null
This topic has been closed for replies.
+24np,
try this
If (IsNull([Current Season Start Date]) OR ToDate([Start Date])>=[Current Season Start Date], true)
or same result but shorter
IsNull([Current Season Start Date]) OR ToDate([Start Date])>=[Current Season Start Date]
When you have a Boolean statement it is going to evaluate to either true or false so you can make a statement and it will either be true or you're lying and it's false.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
try this
If (IsNull([Current Season Start Date]) OR ToDate([Start Date])>=[Current Season Start Date], true)
or same result but shorter
IsNull([Current Season Start Date]) OR ToDate([Start Date])>=[Current Season Start Date]
When you have a Boolean statement it is going to evaluate to either true or false so you can make a statement and it will either be true or you're lying and it's false.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
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.