You can create a calculated field from the (date) calculation above and use it as a filter in the Extract Data dialog box similar to the following:
[Order Date]>=dateadd('month',-12, today())
Then, filter to True.
Hope this helps!
I tested that and it works great.
Can I ask one further question. How can I change it slightly so that it doesn't choose the latest x months based on today, but chooses the latest x months based on what's available?
Ah-ha - found a way to do this by using 'Top' and then the formula.
Another related question - how do I go about editing the filters and regenerating the extract once it is set up? I know how to refresh, but can't seems to see how to edit?
1 of 1 people found this helpful
One way you can do is remove the extract, go to Data-->extract name-->Extract-->Remove. Then, create a new extract with the desired filters.
That's what I suspected, thought I would just ask to see if there is an easier way. I have had some problems with calculated fields, parameters, sets etc when I change data sources, but thats for another post another day!
Thanks for your help.