Updating of Custom Date Range Filters
Custom report date range filters that use BETWEEN and a relative date are calculated dynamically based on the current date when you run the report. This automatic updating overwrites the values you selected when you first customized the report. However, when you show the custom date range filter in the report footer and the user selects refresh, the operator changes to CUSTOM, and the values update to what you originally selected.
When you define a custom date range filter such as “this week”, the report data filters by the dates in the From and To fields. The report keeps using those dates over time. For example, if you set the following filter for “this week”, the report returns the current week's data until 8/2/2014. After that date, you need to update the filter to the following week's dates. Otherwise, the report continues to show results for 7/27/14-8/2/14.
If you filter a report for a specific date or period range, results may differ for users in other time zones. Reports follow the time zone preferences you set at Setup > Company > Preferences > General Preferences or Home > Set Preferences when calculating report date fields with timestamps. Report results for these fields use company or user time zone, not system time zone.