AnsweredAssumed Answered

List of Dates In Between Two Dates

Question asked by scottganderson on Apr 13, 2017
Latest reply on Apr 14, 2017 by jbrown

I have searched and found questions similar to mine but nothing that exactly fits my situation.  I have an events table in which each event has both a start date and an end date.  I'm trying to make a list of every date that an event passes through (start date to end date, inclusive). I added a calculated repeating field in my events table, hoping to populate it with one entry for each date that includes a given event, but I can't quite figure out how to get the data into the field.  I was hoping to do it with a simple Boolean calculation, but if that's possible, I can't seem to do it.  Could be that it's achievable through a short script that runs each time a new event is created, but again, I'm unsure if that's the right way to go.  I'm hoping for some guidance in this matter if anyone has a suggestions.  Thanks in advance.

Outcomes