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 · Accepted solution]

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.

[Kai Becker]

@İclal Aslan did you get an answer in the Confluence forum?
Would you mind closing your answer here then?

[İclal Aslan]

Hello,

In the confluence forum people said it is not possible.

There were some suggestions tho.

But I'll add the link here : https://community.atlassian.com/forums/Confluence-questions/Send-email-before-the-end-date-on-the-table/qaq-p/3157456#M351954