Offers Accepted - 1 day ago

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.