JQL Question - Date Picker Custom Field And Add 1 Day

MAG-II

Apologies for the confusing title of this post. What I am trying to achieve via JQL shouldn't be too difficult. 

I have a Date Picker custom field titled "Visit End Date." I am trying to figure out the JQL to pull the current date of whatever is entered into this field, but add one day.

I understand that "Visit End Date"=now() will give me Issues that reflect the current date, I'm just not sure how to write JQL that gives me the date of whatever was entered +1 day.

What I ultimately am trying to achieve is via the Automation for Jira plugin, have an automatic transition that happens 1 day after whatever date was entered in this field.

 

Any help would be much appreciated.

Jack Nolddor [Sweet Bananas]

Hi,
Try to configure an automation that runs daily and transition issues to the desired status.

To pull "yesterday" issues use this JQL filter:
"Visit End Date" >= startOfDay(-1) AND "Visit End Date" < startOfDay() 

It should be work.

Kind Regards.