Date query is not working with equals operator

[Allan Ferreira]

Hi everybody,

I'm having this strange issue with dates. If I try to query a date with the equal operator (eg updated='2013/08/16') I do not get any result back. On the other hand, if I query with equal or greater than (eg updated>='2013/08/16') it works properly. Does anyone know what I'm doing wrong?

Thanks

[Udo Brand · Accepted solution]

Updated is a date time field where you have beside the date part also a time component in it. So you query "updated ='2013/08/16'" means actually "updated ='2013/08/16 00:00:00'" (or even to millisecond part). Since no issues where updated at midnight (only later) you get no results with your equal query, however your greater then query works.

Hope I could help.

[Allan Ferreira]

You certainly did, Udo Brand.

So, would it be possible somehow disregard the time part of it? The way I'm doing is constraining the query with both >= and <= (which should be < in fact). That seems not to be correct.

Thanks.

[Udo Brand]

I'm not aware of a way to eliminate the time part. So you will have to use ">= and <"

[Norman Abramovitz]

Depending on the other fields you are testing you might be able to use the WAS clause.

status WAS open ON '2013-01-05'

[Norman Abramovitz]

I was puzzled by your <= comment. Did you write date clause like this?

created >= '2013-02-20' AND created < '2013-02-21'