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!