Forum Discussion

JeffJoyceJeffJo's avatar
JeffJoyceJeffJo
Qrew Trainee
12 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?

Tables and fields
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
12 years ago
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
7 years ago
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.