Forum Discussion

ChrisFaye1's avatar
ChrisFaye1
Qrew Cadet
6 years ago

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 Date]=null OR ToDate([Start Date])>=[Current Season Start Date], true, false)

Thank You in advance for the help!

------------------------------
Chris
------------------------------
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 years ago
    np,

    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
    ------------------------------
    • ChrisFaye1's avatar
      ChrisFaye1
      Qrew Cadet
      6 years ago
      Thanks so much, Mark!!!

      Makes total sense!

      ------------------------------
      Chris
      ------------------------------