I'm currently trying to set up a report that goes out daily that summarizes the changes made over the past day. Ideally I'd like this report to go out each day at 5pm, and contain only the changes over the past 24 hours, so from 5pm the previous day, until 5pm the current day.
Within the setup for the change report, I can set it to "Show me changes over the past x days." When I try to set this to 1, rather than the past 24 hours, it seems to include any changes made at all the previous day, as well as anything made that day. This causes any changes to show up in the report two days in a row. I can set the value to 0, and it will include changes made only the current day, so from 12:00am until the report goes out at 5pm. This is better as information isn't duplicated on consecutive days. However, it also means any changes that may be made after hours between 5:00 and midnight will not be caught in either report.
Now, at this point, the best solution I've found is to run the report at 11:59 each night, set to the past 0 days. This includes all changes made that day, and nothing is duplicated. However, it also means that we don't receive the report until the next morning.
Is there a setting I'm missing somewhere that would give me finer grained control over the range included in the change report?