How to set a default date in a prompt that automatically adjusts. In other words, how to prompt for "10 days ago."
More options with dates
We go further with date calculations to show how we can limit queries to just the previous month's set of data.