Forum Discussion

Qrew Trainee

3 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

Qrew Legend

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

Qrew Trainee

3 years ago

Thanks @Mark Shnier (Your Quickbase Coach)! That worked!

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