Help

Formula help setting service date and time

910 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Susan_Anderson
4 - Data Explorer
4 - Data Explorer

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.

1 Reply 1
Matthew_Moran
7 - App Architect
7 - App Architect

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?