Discussions

 View Only
Expand all | Collapse all

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

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

    Posted 03-15-2014 17:43


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

    Posted 03-15-2014 20:10
    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)


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

    Posted 06-13-2018 19:21
    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.


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

    Posted 06-13-2018 22:35
    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)


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

    Posted 03-16-2014 13:58
    Thank you.