You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Termination Date less than and greater than 3 months of current date

Accepted answer


I'm trying to work out how to write a formula for a Leavers report that will bring back everyone who has left the department in the last 3 months and projected leavers in the next 3 months .

I found the code below in the Advanced SQL Filter of another report which looks at Leavers in the last Previous Calendar Month and as I'm new to Oracle and SQL I could only work out what some parts of this syntax was doing. Can someone please show me which part of the syntx after AND I would need to change to get projected termination dates?


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!