5 Replies Latest reply on Dec 11, 2012 6:02 PM by Nathan Schofield

    Filtered Extract based on 'last x months'

    Nathan Schofield

      Hi All,


      I have a DB that will be monthly updated with data. I want to create an extract of the last 12 months rolling.


      Firstly my date is in the format e.g. '2012-01', so generally I have done something like this to read it in:




      How do I create a filter on the extract to only pull in the last X months?

      I note that for the filters for the extract there are limited formula options (e.g. no WINDOW functions), which makes sense.




      Nathan Schofield