Forum Discussion

ToddMolino's avatar
ToddMolino
Qrew Cadet
5 years ago

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
------------------------------
  • np,
    If(
    FirstDayOfWeek([Scheduled Appointment Date]) = FirstDayOfWeek(Today()), true, false
    )

    ....

     you can also just do this

    FirstDayOfWeek([Scheduled Appointment Date]) = FirstDayOfWeek(Today())

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • ToddMolino's avatar
      ToddMolino
      Qrew Cadet
      Thanks very much Mark. I really appreciate it. Worked fine.

      ------------------------------
      Todd
      ------------------------------