Given a date, is it possible to create a list consisting of the 30 days prior or after?
ie:
given: 11/14/2014
list:
10/15/2014
10/16/2014
.
.
.
11/11/2014
11/12/2014
11/13/2014
I know you can do date differences but I'm not sure how/if that is going in the right direction to create such a list
You'll need a date dimension table for that over relational, and a date dimension in your OLAP solution over dimensional.