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?

Thanks

1 answer

1 accepted

This widget could not be displayed.

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.

Thanks.

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
Posted Tuesday in Jira

What modern development practices are at the heart of how your team delivers software?

Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...

171 views 1 3
Join discussion

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