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.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Query help needed to determine duration in job code, title, pay grade
Summary
Query generates a list of the job code, title and paygrade combinations for an employee with start and end datesContent
Hi All,
I have seen several queries regarding the current and previous values and those have gotten me close to what I needed but not completely.
I am creating a report that shows an employees current job code, title and pay grade with the effective date and how long they have been in the combination. I also need to display the previous information.
The flaw that I seem to be hitting with any current and previous reports is that the "Previous" information may be the same as the current information because of a different transaction.