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.
Returning data based on two columns
Summary
Data must be returned if either of the criteria satisfiedContent
HI all
Any ideas how to do the above.
I am working in Absence Calendar and have the start and end dates of the absence however the prompt must include the data if any of the dates between the start date and end date fall between the prompt dates.
e.g. the prompt dates are 01/01/20 and 31/01/20
Person 1 has an absence that started on 31/12/19 and has no end date - Included
Person 2 has an absence that started on 31/12/19 and ended on 31/12/19 - Not included
Person 3 has an absence that started on 31/01/20 and has no end date - included
Tagged:
0