AnsweredAssumed Answered

Incorrect results while filtering mObjects using datetime fields

Question asked by af17a8ec06cd192b9d2519a40fc2fa2a9435f74a on Oct 3, 2013
Latest reply on Dec 18, 2013 by af17a8ec06cd192b9d2519a40fc2fa2a9435f74a
When filtering mObjects with a datetime field, it looks like the timezone is not taken into consideration.

getMObjects with the below criteria returns the results correctly.
     <mObjCriteria>
     <attrName>ExternalCreatedDate</attrName>
     <comparison>EQ</comparison>
     <attrValue>2012-08-03T12:24:23-05:00</attrValue>
     </mObjCriteria>

whereas the below query is returning zero results
     <mObjCriteria>
          <attrName>ExternalCreatedDate</attrName>
          <comparison>EQ</comparison>
          <attrValue>2012-08-03T17:24:23+00:00</attrValue>
          </mObjCriteria>
           

If you observe the timestamps are  2012-08-03T17:24:23+00:00 and 2012-08-03T12:24:23-05:00 which are equal and should return the same results.

In addition it looks like the timezone is not considered properly, the above filter on 
2012-08-03T12:24:23-05:00 (or) 2012-08-03T12:24:23+05:00 (or)  2012-08-03T12:24:23+00:00 (or) 2012-08-03T12:24:23[Anytimezone] returns the same results.

Is it a bug? Can someone confirm this.

Outcomes