Date field not returning the expected results.
Using the following query, I would expect an item with the following value for that field to be returned: '9/1/2014 12:00:00 AM':
(@foriginalz32xpostedz32xdate29877>=2014/09/01 AND @foriginalz32xpostedz32xdate29877<2014/09/02)
But it does not return anything. With this query:
(@foriginalz32xpostedz32xdate29877>=2014/08/31 AND @foriginalz32xpostedz32xdate29877<2014/09/01)
There are results.
Could it be because of the way date-only fields in Sitecore are indexed (having the 12:00AM time tacked on)? Could the processor be calculating '9/1/2014 12:00:00 AM' as '8/31/2014 11:59:59 PM'?
Is there a format to filter by time as well as date?
That is certainly the problem, as a date with no time defaults to midnight. The syntax for specifying time in a date query is described here: http://onlinehelp.coveo.com/en/ces/7.0/user/narrowingresultsby_date.htm.