As an admin, I'd like to set a date comparison condition in the workflow as a JQL search

Problem Definition

At this moment, when creating a date comparison condition in a workflow, admins can only use a fixed date.

When we need a condition where the transition is only available if the "Date Picker" custom field is set to less than 6 months from now in the future. Examples:

• Today is 09-12-2018. If the "Date Picker" is set to 11-12-2018, then the transition is available;
• Today is 09-12-2018. If the "Date Picker" is set to 04-12-2019, then the transition is unavailable;

This is not possible using conditions, right now.

Suggested Solution

Add the ability for admins to create a date comparison condition based on a JQL search.

Why this is important

This should enhance greatly the user experience.

Workaround 

(Please note: At this moment, this workaround can be done only by Jira admins!)
We can add a Date Compare Validator, which has broader options for date comparisons. To achieve this:

1. Type the g key twice on your keyboard (gg) or, as alternative, your period key ( . ), then Projects;
2. Select the relevant project;
3. Click workflows;
4. Find the relevant workflow for the relevant issue type, then click the Pencil icon on your right corner;
5. Select the relevant transition, then click Validators;
6. Click Add Validator, select Date Compare Validator, then click Add;
7. Configure the validator as needed, then click Add;
   • Perform steps 5 to 7 on all relevant transitions!
8. Don't forget to publish the workflow draft!

The only drawback is that the transition will always be available (as we are not working with conditions), but Jira will throw an error with an understandable message on it.