Forum Discussion

SherryBlackbur1's avatar
SherryBlackbur1
Qrew Trainee
2 years ago

Formula for Cancellation Deadline (15th of month prior to month of date field)

In an app that allows users to book a shift: Users are allowed to cancel their shift up to the 15th of the month prior to their [shift date] - for example, if my [shift date] is 1/6/23, I cannot cance...
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion
not tested but try this as a formula checkbox called
[OK to Cancel Shift?]

var date LastDateToCancel = AdjustMonth(FirstDayOfMonth([Shift Date]),-1) + Days(14);

Today() <= LastDateToCancel

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
SherryBlackbur1's avatar
SherryBlackbur1
Qrew Trainee
2 years ago
Thanks @Mark Shnier (Your Quickbase Coach)! That worked! ​

------------------------------
Sherry Blackburn
Sr. Applications Systems Analyst (Quickbase at PeaceHealth)
PeaceHealth
------------------------------