Relative Date Queries with Confluence

[Robert Reiner _smartics_]

I'm trying to run a Confluence query with a relative date. Specifically I want to fetch documents created within the last X days (from the search field within Confluence).

What works is this:

created:[20150311 TO 20150317]
created:[20150311 TO NOW]

But what I would like to run is something like this:

created:[NOW-7DAY TO NOW]
created:[StartOfWeek TO NOW]

I already tried without success some formats with inspiration from

• https://developer.atlassian.com/confdev/confluence-rest-api/advanced-searching-using-cql
• https://cwiki.apache.org/confluence/display/solr/Working+with+Dates
• https://answers.atlassian.com/questions/74444

https://jira.atlassian.com/browse/CONF-10107 and the fact the the keyword "NOW" is supported makes me think that there is a solution to my problem. But I cannot find any documentation on this topic.

Is there documentation on the syntax of relative date range queries with Confluence? Or is this not supported?

[Stephen Deutsch · Accepted solution]

Hi Robert,

CQL supports this, but it's not yet fully supported in the interface.  If you are running Confluence Cloud, I wrote an add-on to expose it in the interface: https://marketplace.atlassian.com/plugins/cql-search

Otherwise, I'm afraid you're stuck with the syntax that worked for you above, at least until Atlassian implements it in the interface for all users (or I get around to writing a Confluence Server version of the add-on).

However, don't forget that you can limit your search with the options on the left side of the screen from the search page (unfortunately, it only works for last modified).

[Robert Reiner _smartics_]

Hi Stephen, thank you very much! Robert