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 for Hire Date + 30 days
Summary
does anyone have a quick SQL for finding employees hitting their 30 day mark after hire?Content
Hi folks - hoping this is an easy one! Does anyone have a quick and easy SQL for OBI: need to identify employees hitting their 30, 60, and 90 day make of tenure with the company. Is this is easy as:
Enterprise Hire Date = CURRENT_DATE-30? This doesn't seem to work in BI. Is there a better SQL criteria to identify these folks?
0