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.
Filter hire start date with only previous month
Content
Ok, I'm trying to run a report that involves only showing those that had a hire start date of the previous month.
For the column I'm using MONTHNAME("Submission.Dates"."Hire Start Date") so that the column only shows the month.
Then I'm filtering that using the TIMESTAMPADD command like this because I only want the previous month:
MONTHNAME("Submission Dates"."Hire Start Date") = TIMESTAMPADD(SQL_TSI_MONTH, -1, CURRENT_TIMESTAMP)
I know there are results because without the filter I see Nov in the column I created. But when I add the filter, it throws an error:
Error Codes:
Tagged:
0