I know this is pretty simple but this isnt working for me for some reason.
All i want to do is return staff who have been at the company 5 years from their ORIG_START_DATE. I only want this to return people who have been working for 5 years in the month they have been working 5 years.
AND ADD_MONTHS(D550M.ORIG_START_DATE,5*12)BETWEEN sysdate AND sysdate+31
What am i missing?