How to send due date reminder 1 day before the task due date?

[Pramodya Gamaethige]

Hi, I have created an automation rule to send an email alert for the assignee 1day before task due date but its not working as expected.

Please support if you notice any errors in the rule or know any alternative methods.

[John Funk · Accepted solution]

Hi Pramodya,

We use:

duedate <= startOfDay(1)

[Pramodya Gamaethige]

Much thanks @John Funk 

[John Funk]

Can you click on the Accept Answer? Thanks!

[Yadi · Accepted solution]

In my case, not all field supported by "Issue Field condition" so i solved by add condition in JQL "Document Expiry Date" >= 0d AND "Document Expiry Date" <= 1d, in your case you can add and "due" >= 0d AND "due" <= 1d in JQL condition in part of scheduler trigger as mention by @Vahagn Beglaryan.

[Pramodya Gamaethige]

@Yadi MuchThanks due=1d worked for my scenario. 

[Vahagn Beglaryan · Accepted solution]

You can use "due > now() and due <= 1d " in you JQL Condition

[Pramodya Gamaethige]

@Vahagn Beglaryan  Much Thanks due=1d worked for my scenario. 

[Mizba Popat]

Hi @Pramodya Gamaethige . Could you please explain me the JQL query project = "Group ERP Project Tasks" AND statusCategory !=Done. 

I am trying to create a rule to send an email one day before the due date but this is my first time, could you help please.

Thank you :)