Automation to create issues on specific date field

[Ajay Goud Gaddam]

Hi , 

Can you please help here we have an automations for Leavers forms. for these the automation will create issues to different teams to deactivate the the accounts of the the leaver and linked to the main leaver form and also notification emails are sent on the same for teams. the current process triggered on the creation of the ticket.

But now, we want to update rule based on the "Execution date" the linked issues and notifications are to be sent only on this date.

I tried with two different automations 

trigger : Issues created

Condition JQL =  execution day is now or the past

Action = issues created and linked to current issues and notification are also sent.

these working as expected as the current automation. But we need to creat autromation if the Exception date is  greater than to day.

we need to create the linked issues and send notifications on the day of excecution day only.

Will it will have any suggested workaround.

Thanks.