2 Replies Latest reply: Jun 27, 2016 2:49 AM by Varsha Vig RSS

    data restriction to 3 years

    Putturu Divya

      Hi Everyone,


                        I am using Employee database,it contains 10 years of data(2006-2016) .

      My Scenario - I need to extract only 3 years of data (2014-2016),and i have to consider active employees those whoever joined on 2006 as well.


      I have written the below Script for restriction:


      ((EFFECTIVE_TO_DATE=today() or DATE_OF_JOIN>=MAKEDATE(2014,01,01)) or DATE_OF_RESIGNATION>=MAKEDATE(2014,01,01))

      Please find the attached sample data.


      Any suggestions would be greatly appreciated.


      Thanks & Regards,