Hello All,
I have a formula that tells me that an Appt. date is within the current month, however I'd like to drill down even farther to tell me if the Appt. Date is during the current week. This is for scheduling purposes so I can summarize how many appts the Employee already has scheduled this week so I don't exceed the limit of #of appts in a week. Hope this makes sense. Here is my formula for the monthly version.
Formula Check Box:
If(
Month([Scheduled Appointment Date]) = Month(Today()), true, false
)
------------------------------
Todd
------------------------------
Question
Formula Check Box to Check if Appt Date is During the Current Week
This topic has been closed for replies.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.