Formula Checkbox - If Date Field = Null
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 ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnp,
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
------------------------------
- Thanks so much, Mark!!!
Makes total sense!
------------------------------
Chris
------------------------------
