Question
How does time range work with date criteria?
Answer
When selecting the time range, the criteria is applied as a whole number. This is true whether defining days, weeks, months, or years.
Examples:
- To target a time span of 18 months, select 0 -17 months, as this setting includes 18 months.
- To include 2 years, use 0-23 months as this includes the 24 months. If 0-2 years is selected, 3 years will be included (0=year 1, 2=year 2, 2=year 3).
- To include 4 weeks, use 0-3 weeks as this could include 32⁄7 weeks or 36⁄7 weeks.
