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:

       

      DATE(RIGHT([Period],2)+'-01-'+(LEFT([Period],4)))

       

      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.

       

      Regards,

       

      Nathan Schofield