Query on datetime: no results
I just installed the latest version of Coveo for Sitecore (October 2015). We have have some calculated date fields, these fiels should be written in the format yyyy/MM/dd@HH:mm:ssZ, the Z is new in this release (should be added to the release notes).
When I run a query where I use the date in the where statement, like:
items = context.GetQueryable
this query gets converted to:
This query results in zero items. When I run the query in the CES Administration Tool on the index it results in zero items, when I remove the Z from the query it returns items
Any idea why the Z is added in my query??
Thank you for your feedback. The
Z was added to the date time value so CES can know we are passing UTC time. We also had to change CES's date format string to be able to parse the timezone information from the dates.
Rebuilding the Coveo indexes will fix both the CES fieldsets and the date values on the indexed documents.
Let me know how it works Thanks
Anyone have an answer to this post that works? I have the same situation where the query is not returning results when Z is on the end of the date string.