search on date

[Peter Wise]

Hi All

I am having issues working with the date search. 

I have tried the ideas here: 

https://community.atlassian.com/t5/Jira-Software-questions/I-want-to-search-my-jira-defects-based-on-date/qaq-p/996385

if I put  " createdDate = 2019-03-05 " in the search but I get 

No issues were found to match your search

But there is a ticket with 

Created: 05/Mar/19 9:36 AM

Updated:  05/Mar/19 9:36 AM

I have also tried 

createdDate = 4w

createdDate = -4w

createdDate = "4w"

createdDate = "-4w"

What am I missing here?

Thanks

Peter

[Merle Fischer · Accepted solution]

Hi @Peter Wise 

As for Issues created on a spceific date, try:

createdDate >= 2019-03-05 AND createdDate < 2019-03-06

As for your queries for trying to find issues that were created in the last four weeks try this:

createdDate >= -4w

Let me know if these work for you

Cheers

Merle

[Peter Wise]

createdDate >= 2019-03-05 AND createdDate < 2019-03-06

and 

createdDate >= -4w AND createdDate <= -3w

worked for me.

It seams you cant just use equals.

 Thanks 

[Alexey Matveev]

Hello,

createdDate = "2019-03-05 " means createdDate = "2019-03-05 00:00:00 ", which does not equal to your dates. You should search the way @Merle Fischer suggested

[Peter Wise]

umm.. I guess I am a bit funny in the head then. As date to me implies the whole day an that would be the whole of a 24 hour period not just a specific  time point in the day.

also if  I put in createdDate = "2019-03-05 00:00:00 "

I get the error message.

Date value '2019-03-05 00:00:00 ' for field 'createdDate' is invalid. Valid formats include: 'yyyy/MM/dd HH:mm', 'yyyy-MM-dd HH:mm', 'yyyy/MM/dd', 'yyyy-MM-dd', or a period format e.g. '-5d', '4w 2d'.

This also does not cover createdDate = 4w as that should be over a week or maybe I am just really funny in the head?

but meh... Merle's answer works for me

[Alexey Matveev]

You can use createdDate = "2019-03-05 00:00", but still it will not choose any of your issues. That is what I wanted to say, that you should query as suggested by @Merle Fischer