Skip to main content
Question

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

How do I automatically check a checkbox if [DATE] = the prior business day and uncheck the checkbox if [DATE] <> the prior business day?
This topic has been closed for 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)
Thank you.
Terms & ConditionsAccessibility statement