when i tried with != Operator i got the correct result.
Project = eureka and Created != "2015/01/16"
With this JQL
Project = eureka and Created = "2015/01/15"
I haven't able to fetch the result.
atlassian_ans.PNG
The problem is the created timestamp also contains a time part like "2015/01/15 12:15:00". If you write "2015/01/15" this is equal to "2015/01/15 00:00:00".
So Project = eureka and Created = "2015/01/15" means all issues from project eureka created at midnight on 2015/01/15. That is why you find no issues.
Hi Brand Thanks for the Answer I have tried in this way which you have suggested 1.project = test and created = "2015/01/15 10:57" No Issues were found to Match Your search 2.project = test and created >= "2015/01/15 10:57" One issue which has a Created Value = "2015/01/15 10:57" 3.project = test and created >= "2015/01/15 10:57:00" Got an Error Message "Date value '2015/01/15 10:57:00' for field 'created' 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'." My Jira Version Is 6.4.1 System Date/Time format is "yyyy/MM/dd HH:mm"
Yes, the format is only containing hours and minutes but the timestamp also contains seconds (not sure about milliseconds). So if you want to find issues created within a certain minute use project = test and created >= "2015/01/15 10:57" and created < "2015/01/15 10:58"
Hi, Thanks for your answer Previously i also tried with TO_DATE('9999/12/31', 'YYYY/MM/DD') But format error will occur. Thanks
It looks like you're new here. Sign in or register to get started.
