ToddMolino
5 years agoQrew Cadet
Formula Check Box to Check if Appt Date is During the Current Week
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
------------------------------
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
------------------------------