JQL for the total ticket of yesterday

[Rodriguez, Jhon Ronald]

I am creating a report for our all ticket logged as of yesterday, what is the proper JQL for my filter to be created.

[Brittany Wispell]

Great! You're welcome. 

[Rodriguez, Jhon Ronald]

wow. now it works fine. so may thanks and appreciate your help.

[Brittany Wispell]

Ah yes, sorry about that. So the created >= -1d will include anything created in a 24 hour time period. So it is grabbing tickets from say 9am yesterday to 9am today. 

So you'll want this: 

project = <project name> AND created > startOfDay(-1)  AND created < endOfDay(-1)  

Hope this works this time!

[Phill Fox]

Just to add to the answer from @Brittany Wispell 

You should be aware that this approach will use whatever is your local time to determine the start and end of day. So users located in different parts of the world can see different results.

[Rodriguez, Jhon Ronald]

i applied the JQL but it still cover the some parts today.

[Rodriguez, Jhon Ronald]

this is dynamic approach so the data will change everyday. thanks so much

[Brittany Wispell]

Hey @Rodriguez, Jhon Ronald 

I believe you're looking for something like this: 

created >= -1d order by created DESC

You can also switch to 'Basic' mode with JQL to make creating date specific queries easier. 

Here's some more information on Advanced Searching.

Thanks,
Brittany