This content has been marked as final. Show 2 replies
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,