Send email before the end date on the table

[İclal Aslan]

I have a table which shows the end and start dates of the certifications.

I want to send an email 2 days before the end date. I used this smart value condition but it does not work. And even I do it this way I do not know how it would work for multiple end dated certifications.

{{ page.body.match("\\d{1,2} \\w{3} \\d{4}").last.toDate.minusDays(2).format("yyyy-MM-dd") }}

equals

{{today().format("yyyy-MM-dd") }}

[Kai Becker]

Hi @İclal Aslan 

thank you for your question. It looks like this is a Confluence topic, but you ended up in the  Jira forums. You should go ahead and recreate your question in the Confluence area.

May I ask why you are storing this information in Confluence directly?

My advice:

• Store the information as work items in a project
  • Use Jira automation to get all the work items from a JQL
  • Use a branch to go through all of the work items and send an email for each one
• display the information via the Jira macro on the Confluence page

[İclal Aslan]

They want to see and able to edit in confluence I recomment jira but they said confluence page is their choice. But my recommendaiton to them is exacly what you recommend.

[İclal Aslan]

Also thank you for the correciton I will re post it on confluence.