Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

In filter (JQL), compare a date (e.g. "10/7/2018") with a datetime field (e.g. created)

Wayne Erfling
Contributor
February 12, 2019

How can I compare a date to a datetime in JQL?  Here we're speaking of the "created" field

In MS Transact-SQL, this would be as simple as:
   CONVERT(date, created) = '10/7/2018'

But I can't find any date conversion functions at all in Jira (Server) 7.12

Do I really have to do the following?:

   NOT (created >= '2018/10/07' AND created < '2018/10/08')

Thanks!

1 answer

1 accepted

0 votes
Answer accepted
Dharma Ramos
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 13, 2019

You do have to do something like the latter:

  • Find issues created on 15 January 2011:
    created > "2011/01/15" and created < "2011/01/16"

https://confluence.atlassian.com/jirasoftwareserver0712/advanced-searching-fields-reference-959315334.html

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events