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,

      P.Divya