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 analysis does not bring all records when dynamic dates are used
Summary
When a hard coded dates are used in the analysis or date is entered through the prompt selection, it works fine. However when the range is determined dynamically it does not work.Content
Hi Experts,
I'm using the following dynamic dates to calculate the beginning and ending dates for termination analysis for a dashboard:
"Worker"."Termination Date" >= (greater than or equal to) TIMESTAMPADD(SQL_TSI_YEAR,-1,@{asofdate}{CURRENT_DATE})
to
"Worker"."Termination Date" <= (less than or equal to) asofdate
This brings most of the records but missing some latest records. However, the same analysis works fine when I hard code the same date (e.g. 5/15/2020 - 5/15/2021).
Tagged:
0