Dynamic relative filtering

I would like to be able to set a relative date based on an advanced filter. For example, I would like to filter to the 12 months leading up to a specific date (based on an advanced filter). This needs to be dynamic, so when a new month end date occurs, it steps forward a month.