Incorrect results while filtering mObjects using datetime fields

Anonymous
Not applicable

Incorrect results while filtering mObjects using datetime fields

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.
Tags (1)
1 REPLY 1
Anonymous
Not applicable

Re: Incorrect results while filtering mObjects using datetime fields

Can somebody reply to this question.