5 Replies Latest reply on Dec 23, 2015 4:43 AM by Naama Galor

    extract refresh filter to exclude the current month

    Naama Galor

      Hello Experts

       

      I am looking for a way to add a filter to an extract (full refresh) which will take all data from the source but without the current month data.

      something like select * from X where action_date < trunc(sysdate, 'MM')

      if we were running it on an ORACLE DB

      is this option possible?

       

      thank you!

      Naama