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 that you could drag into your report/filter that allowed you to do this without writing any formula.
Tagged:
0