Dynamic Date and Time

Harut Avetisyan

Hello everyone.

Is it possible to search for issues with dynamic date and time, for example, if issues are created today from this morning at 09:00 am to 09:00 am tomorrow morning.

project = ("project") AND created >= "2023-11-23 09:00" AND created <= "2023-11-24 09:00"

Ste Wright

Hi @Harut Avetisyan 

JQL will search for existing issues - so it could look back 24 hours from today to yesterday.

There's a few options with date searches:

• Date/Time: Your JQL above
• Timeframe: This could give different results depending on when it is run. You can use this for different time periods - like weeks, days, hours, and minutes.
  • eg. created >= -1d
    • Provides all created issues which were created since yesterday
• Functions: These perform a calculation based on set parameters - and allows you to search for things like start of day, end of day - and can also be used with week, month or year.
  • eg. created >= startOfDay()
  • eg2. created >= startOfMonth(-1)
    • The -1 sets the date to the start of the previous month

See more information on these help pages: https://support.atlassian.com/jira-software-cloud/docs/use-advanced-search-with-jira-query-language-jql/

If there is a specific outcome you're trying to achieve, let us know so we can assist further

Ste