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

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 Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,754 views 11 18
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot