Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Termination Date less than and greater than 3 months of current date — Cloud Customer Connect
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
11
Views
3
Comments
in Reporting and Analytics for HCM 3 comments

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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