This site is moving soon to become part of an integrated Appfire documentation and information site for our apps. This site will remain available during the transition to our new and improved site. Once this site is moved over, this banner will be updated with the new site link for easy access.

Take a look here! If you have any questions please email support@appfire.com

Dates with Time

Owned by Daniel Turczanski
Last updated: Aug 14, 2023 by Deborah Scott
1 min read

Most Jira date fields also contain the time component. Jira doesn’t currently support convenient use of = and IN operators with timestamps. You should use the comparison operators instead: <, <=, >, >=

The following JQL keywords contain timestamps:

  • attachedOnDate

  • updatedOnDates

  • commentedOnDate

  • commentUpdatedDate 

For example, this query fails to find issues commented on a particular day:
commentedOnDate="2020/06/01"
Jira returns an empty result even if there are issues that were commented on 1 June.

The workaround is to search for the range of dates:
commentedOnDate>="2020/06/01" AND commentedOnDate<"2020/06/02"
Jira returns issues that were commented between midnight 1 June and midnight 2 June.