Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Termination Date less than and greater than 3 months of current date
Summary:
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?
Tagged:
0