Date Filter - 1 day ago
Summary
Process End Date - 1 day agoContent
Hi.
I am trying to extract candidate information who's processes ended 1 day ago. I am using the below filter, how ever it checks the timestamp (-24hrs) and not the date in the MM/dd/yyyy format.
For example, if i am running today (02/28/2019) i need records from 02/27/2019 only. But the below filter also pulls records got completed on 02/26/2019, since it considers the timestamp which includes HH:MM:SS.
<quer:filtering xmlns:quer="http://www.taleo.com/ws/integration/query">
<quer:greaterThanOrEqual>
<quer:field path="Process,EndDate"/>
<quer:add>
<quer:date type="now"/>
Tagged:
1