Hours Logged for Last Calendar Week Report

[Tarfon, Carla]

I'm having trouble entering a JQL to pull a report for total hours logged for the last calendar week within a specific project. 

I've tried this:

project = "NewsDNA Editorial Design" AND worklogDate >=startOfWeek(-6) AND worklogDate <= endOfWeek(-6)

But no issues or data is coming up (even though it has a green tick). 

Is there another code i should be trying? 

TIA.

[Édpo César]

Hello, @Tarfon, Carla

Could you try this query?

project = "NewsDNA Editorial Design" AND timespent is not EMPTY AND resolved >= 2022-02-07 AND resolved <= 2022-02-14

[Tarfon, Carla]

Hi Edpo, 

I've tried that query, however it's not bringing up any issues/data at all. I'm not sure why...

Would the above also mean i'd have to amend the date every week i'd like to run it? Ideally, i'd like a query that stays live and updates automatically to the previous calendar week ongoing...   Not sure if this is all possible...