We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

Offers Accepted - 1 day ago

Accepted answer
41
Views
5
Comments
edited Feb 27, 2019 2:56PM in Reporting and Analytics Taleo Enterprise 5 comments

Summary

Candidates accepted offer 1 day ago

Content

Hi All,

I am trying to create a report which will present List of Candidates with some personal details, who have accepted Offer the previous day, i.e., if i am running the report today 02/27/2019, it should present the candidate data who accepted the offer on 02/26/2019.

I have used the below filter,

Column: "Submission Dates"."Offer Accepted Date"

Operator: Is equal to / Is in

SQL Expression: TIMESTAMPADD(SQL_TSI_DAY, -1, EVALUATE('LOCALTIMESTAMP' AS TIMESTAMP))

it doesnt produce any results. However if i use the Operator , "Is greater than / equal to" it gives the results. But it also considers the hours and brings in data from last 24 hrs, which includes some data from 02/25/2019 which turned accepted in the late hours.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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