how to filter tickets created in project from 12:30pm to 9:30 pm IST

[Sachin Guttala]

 how to filter tickets created in project from 12:30pm to 9:30 pm IST

[Humashankar VJ · Accepted solution]

Hi @Sachin Guttala 

Can you give a try with the below JQL:

project = "Your Project Name" AND
created >= startOfDay() + "T07:00:00.000+0000" AND
created <= startOfDay() + "T16:00:00.000+0000"

To make it work for the current day automatically, you could modify it like the below:

project = "Your Project Name" AND
created >= "yyyy-MM-ddT07:00:00.000+0000" AND
created <= "yyyy-MM-ddT16:00:00.000+0000"

Hope this helps - Happy to help further!!
Thank you very much and have a great one!
Warm regards

[Sachin Guttala]

Hi @Humashankar VJ 

Thank you for your response. I tried the workaround you suggested, but it didn’t work and threw an error. Please find the details attached.

[Humashankar VJ]

@Sachin Guttala 

Can you update the format from - yyyy-MM-dd to yyyy/MM/dd and give a try.

Regards

[Sachin Guttala]

Hi @Humashankar VJ tried that also but not working.

[Humashankar VJ]

@Sachin Guttala 

Try this and it worked at my end as i converted the time zone to UTC- Update your Project name alone from the JQL:

JQL:

Project = "Support" AND created >= "2024-10-28 07:00" AND created <= "2024-10-28 16:00"

Regards

[Sachin Guttala]

Hi @Humashankar VJ

The workaround worked, but we need to update the date manually every day.