nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Udo Brand

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.

All comments

Udo Brand

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'

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jql