I have a table of events that all have a start and end time/date. The start field is "Start Datetime"
For example, I have event that has a start datetime of 1/1/2019 at 11:00am. All in a date field. 1/1/2019 specificially we use as a generic fallback for old events that didn't have a date. So we pasted in 1/1/2019 at 11:00am
These events are linked to those who participated in them. And they have a payment amount noted.
So I created a rollup field with the intention of knowing how much we paid out to those in the last year.
The rollup seems to be capturing linked events which are clearly older than a year, however, and I'm not sure why.
My rollup filter has the "only include linked records from the Events table that meet certain conditions", and then a filter set to only include Where Start Datetime is Within the past year.
Then it aggregates by SUM(values).
None the less, it's including linked events from more than a year ago, but only those older events tagged as 1/1/19...and I really don't know why. I'm confirmed I have the right field. I'm wondering if it's going by a last modified trigger somehow (doesn't seem to be).