Dynamic Date Range Values
- Today – include the current date ONLY
- Tomorrow – include tomorrow’s date ONLY
- Yesterday – include yesterday’s date ONLY
- This Week – Include all dates for the current week starting with Sunday and ending with Saturday
- Next Week – Include all dates for the next week starting with Sunday and ending with Saturday
- Last Week – Include all dates for the previous week starting with Sunday and ending with Saturday
- This Month – include all dates from the first to the last date of the current month
- Next Month – include all dates from the first to the last date of the next month
- Last Month – include all dates from the first to the last date of the previous month
- This Quarter – include all dates from the first date of the current quarter (1/1, 4/1, 7/1, and 10/1) to the last date of the current quarter (3/31, 6/30, 9/30, and 12/31).
- Next Quarter – include all dates from the first date of the next quarter (1/1, 4/1, 7/1, and 10/1) to the last date of the next quarter (3/31, 6/30, 9/30, and 12/31).
- Last Quarter – include all dates from the first date of the last quarter (1/1, 4/1, 7/1, and 10/1) to the last date of the last quarter (3/31, 6/30, 9/30, and 12/31).
- This Year – Include all dates for the current year.
- Next Year – Include all dates for the next year.
- Last Year – Include all dates for the last year.
- Next 5 days – Include 5 dates total (today + 4)
- Next 7 days – Include 7 dates total (today + 6)
- Next 30 days – Include 30 dates total (today + 29)
- Next 90 days – Include 90 dates total (today + 89)
- Next 180 days – Include 180 dates total (today + 179)
