Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Formula Help - Pulling data since beginning of year
Summary
Writing formula to display results that only coincide with current yearContent
Hello,
I am creating a report that should only pull the candidates that have been hired to a requisition since the beginning of the year. I am having trouble trying to create the formulat in OBI - I want to make it dynamic so that I don't have to change it each year (2016, 2017, 2018, etc.). I thought that I could add a greater than/equal to prompt with the following formula, but that doesn't seem to work:
TIMESTAMPADD(SQL_TSI_DAY, DAYOFYEAR(CURRENT_TIMESTAMP) * -(1) + 1, CURRENT_TIMESTAMP))
In BO, there was a simple object
Tagged:
0