Offers Accepted - 1 day ago
SummaryCandidates accepted offer 1 day ago
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.