Forum Discussion

JeffJoyceJeffJo's avatar
JeffJoyceJeffJo
Qrew Trainee
11 years ago

How do I automatically check a checkbox if [DATE] = the prior business day and uncheck the checkbox if [DATE] <> the prior business day?

4 Replies

  • You can make a formula checkbox field with the following formula

    WeekdaySub(Today(),[Date])=1

    or isfyou prefer the expanded verison for readibility

    IF(WeekdaySub(Today(),[Date])=1,true, false)
    • LeoSanchez's avatar
      LeoSanchez
      Qrew Trainee
      Question ... can i use this to automatically unchecked a checkbox? I need to create a checkbox field that has to be reset to unchecked the first of every month.
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      I suggest that you post this as a new question. You can reference this thread in your post. In that question, clarify if you want to have s data entry checkbox field get reset or a formula checkbox field to be reset (which does not make much sense)