It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Time Since Issues Report query

Hey everyone,

I'm working with the Time Since Issues Report. The report ran correctly with the ‚created‘ date and I had f.e. 4 Issues on a specific day. I clicked on the ‚4‘ to get to the issues navigator. There this statement was displayed:

project = ABC AND created >= 2019-09-17 AND created <= "2019-09-17 23:59" ORDER BY created DESC

Than I changed the report to a custom field called ‚entrydate‘. I clicked on the ‚4‘ and the JQL statement was the following:

project = ABC AND entrydate >= 2019-09-17 AND entrydate <= "2019-09-17 23:59" ORDER BY entrydate DESC

This time I had an red exklamation mark mentioning that

Date value '2019-09-01 23:59' for field 'entrydate' is invalid. Valid formats include: 'YYYY/MM/DD', 'YYYY-MM-DD', or a period format e.g. '-5d', '4w 2d'.

Why is a false JQL query working in the report? That’s a little bit irritating for me.

1 answer

1 accepted

0 votes
Answer accepted

Hi Hannes-83,

It seems that entrydate is a Date Field, instead of a Date/Time field so you must remove time reference in the second term entrydate <= "2019-09-17 23:59"

 

Please, try to use the following JQL query instead:

 

project = ABC AND entrydate >= 2019-09-17 AND entrydate < 2019-09-18 ORDER BY entrydate DESC

Did it worked? ;)

 

Regards

Hi Jack,

thanks for your answer! But my problem is, the report is even running with this invalid JQL Query. So when I run the report and than have a look on the query, I do not do anything, but there's a red exclamation mark under the Query.

Does this make any sense or do I have to accept that this is weired?

Hi Hanned-83,

IMHO an incorrect JQL filter should does not display any data in the report, but not sure if what you are experiencing is the expected behaviour or just a bug...

Regards

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira

The add-in you’ve been waiting for: Jira Cloud for Excel 🙌

Introducing Jira Cloud for Excel Here at the product integrations team at Atlassian, we are thrilled to announce the new Jira Cloud for Excel add-in! This add-in lets you export Jira data directly ...

881 views 7 24
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you