Formula help setting service date and time

I have various records that have various available days. I need each food pantry record to show on the calendar it’s open time of service. I can’t figure out a formula for 2nd Thursday of each month, or Tuesday and Thursdays weekly and how to put in times of service such as 1-3pm or 9am til noon. The goal is for the administrator pulling the calendar can see what time food services are vs what time clothing or shelter services are on the calendar.

Hi Susan,

I would really need to understand more about how your base is structured. Do you have multiple tables? What are the relationships/links?

1 Like

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.