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.
Employees Hired in the Last 7 Days
Content
Hi Guys,
I'm trying to generate a report to show employees who were hired in the last 7 days. I've created a Data model and basically inserted this statement into the model, but I an error saying 'Failed to load SQL': Any ideas?
TIMESTAMPADD(SQL_TSI_DAY, -7, CURRENT_DATE)
Full query below:
select "Worker"."Person Number" as "Person No",
"Worker"."Employee Name" as "Employee",
"Worker"."Person Start Date" as "Start Date",
"Worker"."Employee Date Of Birth" as "DOB",
"Worker"."Manager Name" as "Manager",
"Person Email Addresses"."Email Type" as "Email Type",
"Person Email Addresses"."Email Address" as "Email",
"Person Phones"."Phone Type" as "Phone Type",
Tagged:
2