how to filter tickets created in project from 12:30pm to 9:30 pm IST
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
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.
@Sachin Guttala
Can you update the format from - yyyy-MM-dd to yyyy/MM/dd and give a try.
Regards
Hi @Humashankar VJ tried that also but not working.
It looks like you're new here. Sign in or register to get started.
