Scheduled email when 3 days remain for due date

[eldderri]

Hi friends,

I have a bot to schedule email when only 3 days remain for the due date of maintenance.

the email is not sent when making simulation.How to sole this issue?

[Suvrutt_Gurjar]

Please try 

HOUR([Date prevue De Maintenance]- TODAY())/24 =3

Date and time expressions - AppSheet Help

[eldderri]

Hi,

Sorry,I have made a mistake in testing the bot.It is working now with this expression in my condition:AND([Action] = "Maintenance Programmée", ([Date prévue de Maintenance] - TODAY()) = 3).

When I tested it with your expression ,it stopped working.

Any way,thank you for your reply.

[Suvrutt_Gurjar · Accepted solution]

Thank you for the update. But not sure how the expression 

---

@eldderri wrote:

([Date prévue de Maintenance] - TODAY()) = 3

---

is producing a date difference of 3 days. This is so because when one date is subtracted from another in AppSheet, it gives results in hours , minutes and seconds (hh:mm:ss) and not in days. Example below: when from today which is 27th July, a date of 21st July is subtracted, it give results in hours (144:00:00) which is 6 days.

So one needs to extract hour component from the  result.  by using HOUR() function and divide the hours by 24 to get the number of days between the two dates . The example from the help article is also given below.

So just wondering how 

---

@eldderri wrote:

([Date prévue de Maintenance] - TODAY()) = 3

---

is working for you.

[leefarrell]

Double-check the bot’s configuration to ensure the timing is set correctly for 3 days before the due date. Also, verify if there are any errors in the email scheduling logic or if the simulation settings might be affecting the outcome. If the issue persists, checking the logs for any error messages might provide more insight.

Hope that helps!