How to display resolved date on Issue Navigator with the current date

[Antonio San Nicolás]

I would like to create a filter where I can see how many issues had been resolved.

The idea is subscribe to the filter and in the end of the day receive this filter to see all the issues resolved on the current date.

I think that it’s possible with sql syntax but I don’t know make the syntax.

[Nic Brough -Adaptavist- · Accepted solution]

It's not SQL, it's JQL, similar but different. For Jira 5.1, this works:

resolutiondate > startOfDay() and resolutiondate < endOfDay()

[Antonio San Nicolás]

It's working, thank you very much! =D