I was given a request to modify the Weekly Activity Report for a client that tracks their salespeople’s activities. The current report filters are Salesperson, Start Date and End Date. The problem is they noticed activities are being pulled to the report based on when the activity was ENTERED not the actual Start Date.
When you enter an activity, you can select the actual date of the Activity Type in the Start Date field, HOWEVER, when you filter the dates to that range on the report, the activity does not show up as it is tracked in the system by the Date is was entered.
The screenshot below shows the initial setup of the activity having a Start Date of 9/25/25 but entered on 10/8.

The issue is the Start Date is treated as the Entered Date and not when the activity actually happened. Below you see the report is filtered to show all activities that occurred during 9/15-9/30

Here is the result: No activities are shown.

When the filters are changed to the dates used, then the activities are displayed.

Does anyone have any solutions for this? Thanks!






