I have a JIRA project that has 85 custom date fields, as well as the typical built-in date fields. (This project is used for tracking the development and publication of government regulations.)

I am tasked with developing queries to answer questions about these dates. Examples:

• find all the issues which have any date coming up in the next week

• find all the issues which have no dates in the future

It occurs to me that this is somewhat similar to the problem you solve with the 'text' clause, where the query "text ~ Exception" is a very succinct way to say "which issues have any text field(s) that contain(s) Exception".

I can imagine some syntax like "dates >= 1w" could be a nice solution for example 1 above, if you were to develop a dates clause similar to the text clause.