What are Date Presets?
Instead of manually entering a start and end date every time, AffZero offers date presets — named ranges that are calculated fresh each time a query runs. This means an automation set to “Last 7 days” will always pull the past 7 days, no matter when it runs.Available Presets
| Preset | What it covers |
|---|---|
| Today | Midnight to now, current day |
| Yesterday | Full previous calendar day |
| Last 7 Days | The 7 days ending yesterday (does not include today) |
| Last 14 Days | The 14 days ending yesterday |
| Last 30 Days | The 30 days ending yesterday |
| This Week | Monday through today (current week) |
| Last Week | Full previous Monday–Sunday week |
| This Month | First of the current month through today |
| Last Month | Full previous calendar month |
| This Year | January 1 through today |
| Custom Range | You pick the exact start and end dates |
“Last 7 Days” and similar presets end on yesterday, not today. This ensures you’re always querying complete days with finalized conversion data, rather than a partial day that may still be updating.
Why Timezone Matters
Date presets are calculated relative to midnight in your selected timezone. This is important because:- “Yesterday” in New York (UTC-5) is a different 24-hour window than “Yesterday” in Berlin (UTC+1)
- If you’re running an automation for affiliates in different timezones, the dates in the email should match what they see in their own tracker

