What's new in Customer Journeys?

Connect and learn more! ×
Formula Help - Pulling data since beginning of year — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Formula Help - Pulling data since beginning of year

Accepted answer
60
Views
6
Comments
edited Dec 13, 2022 7:02AM in Taleo Enterprise 6 comments

Summary

Writing formula to display results that only coincide with current year

Content

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!