How can I see ONLY startOfDay() items searched today?

Question

I have a JIRA Search query ( project = 'DT' AND created > startOfDay() AND type = "DT Lite" ) that shows all DT tickets for today, and have the results ported to Google Sheets to update automatically as each ticket is updated.

Problem is, I started this yesterday and today, the query also includes "Yesterdays" results.

Is there any way to limit to "ONLY" Today's results?

Florian Bonniec · Answer

So that means the issue is not with the JQL but about what you have implemented to send the result to Google Sheet.

William Wallace_2h1gwj · Answer

It does, but it keeps adding to the query and updating the sheet. If that makes sense.

Florian Bonniec · Answer

Yes but if you run this query in the Issue Nqvigator in JIRA, does it return the expected result ?