Rollup Field Not Seen as Date/Time in Calendar Automations

Topic Labels: Automations
1059 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer


I have a rollup field that finds the minimum and maximum times that somebody has requested office hours, and therefore creates the start and end times that would go into, say, an Outlook Calendar event. I have confirmed that it is formatted like a date in the pre-rollup field, and it still asks me about how to format the date post-rollup. However, when I want to use these fields in the calendar event creation automation, the field is just blank and my automation breaks. Is there something I’m missing? I’ve tried also creating a formula field that takes the rollup field and formats it like a date, but again still get getting a blank field. It appears to work when I create a strictly-date field, but that defeats the purpose of my rollup.

Any thoughts greatly appreciated!

1 Reply 1

Welcome to the Airtable community!

I suggest you contact support.

When I contacted support about issues relating to using MIN an MAX in rollups of date fields, I was informed that what I was trying to do was not supported. However, my issue was slightly different from yours.