How to set up an automation which emails users when the ticket expiry date is within the next 7 days

Kara Nadarajah

I have an automation set up to run once a week which emails the reporter when the expiry date on a ticket is within the next 7 days. However, when it runs it is notifying users about tickets where the expiry date is more than 7 days in the future. What am I doing wrong? I thought I might be using > instead of < but when I looked at switching that around it looked like this might result in emailing users where the expiry date is in the past. The numberOfDaysBeforeDueInclusion variable is set to 7.

Charlie Misonne

Hi @Kara Nadarajah 

>= endOfDay(7) will indeed return dates more than 7 days from now.

What you need is this:

<= endOfDay(7): everything with a date less than 7 days from now. But this will include items in the past.

So combine with "Expiry date[Date]"  >= now() to get future items only.

Result:

"Expiry date[Date]" >= now() and "Expiry date[Date]" <= endOfDay(7)