Help

Date Limited Rollup Field Not Working?

Topic Labels: Dates & Timezones
274 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Christopher_Can
6 - Interface Innovator
6 - Interface Innovator

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).

Overall I'm just stumped.

1 Reply 1
Sho
11 - Venus
11 - Venus

Could you share screenshots of your grid and rollup setup?