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.
SQL Expression for a specific month and day with a year of current year - 1
Content
Hi -
I need to add a filter to an OTBI report that is hire date greater than 10/1 of the prior year. I would like to make the year dynamic based on the year of the current date so that the report clause does not have to be adjusted annually for our compensation review cycle. How do I concatenate a variable year, YEAR(CURRENT_DATE)-1 to a static date '10/01'?
Any help is greatly appreciated. Thank you!
Julia
Tagged:
1