Date Filter - 1 day ago

Summary

Process End Date - 1 day ago

Content

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"&gt;
  <quer:greaterThanOrEqual>
    <quer:field path="Process,EndDate"/>
    <quer:add>
      <quer:date type="now"/>