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 · Accepted solution]

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

[Harut Avetisyan]

Dear @Ste Wright  Thank You a lot!

This really helps.