Date query is not working with equals operator

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?


1 answer

1 accepted

1 vote
Accepted answer

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.

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.


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

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

status WAS open ON '2013-01-05'

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

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

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,492 views 15 20
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you