Yes, this is possible, but I would avoid the "relative date" option and use a parameter instead. I'm attaching an example another forum member set up, which allows users to select a pre-defined date range, or a custom date range. Note that the dataset used only goes through 2013, so you'll have to manipulate values or change your machine's date/time settings to see some of the options working.
Thank you Matthew
No problem--glad this was useful for you. Shawn Wallwork, I'd transfer all the green stars I've gotten for this workbook to you, if I could. I'd say I've accumulated at least 10 or so, just by posting this workbook.