First Tuesday of the Month
Hey everyone, I've been trying around with this myself, but with no success. Does anyone know how to write a 'Formula - Checkbox' field that is only true if today = the first Tuesday of the month?...
Forum Discussion
Hey Mark,
Thank you for the help. I will start to play around with this, but just to ask, would you know how to turn your formula into a Boolean expression that says if today = first Tuesday of the current month, then true, else false?
------------------------------
Quickbase Admin
------------------------------
MarkShnier__You
Qrew Legend
Qrew Legendvar date FirstOfTheMonth = FirstDayOfMonth(Today());
var date FirstTuesdayOfTheMonth=
Case(DayOfWeek($FirstOfTheMonth),
0, $FirstOfTheMonth + Days(2),
1, $FirstOfTheMonth + Days(1),
2, $FirstOfTheMonth + Days(0),
3, $FirstOfTheMonth + Days(6),
4, $FirstOfTheMonth + Days(5),
5, $FirstOfTheMonth + Days(4),
6, $FirstOfTheMonth + Days(3)) ;
IF(Today()=$FirstTuesdayOfTheMonth, true)
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------