How can I create email notification when one of the assets will expire within 45 days?

[Vera Valshonok]

How can I create email notification when one of the assets will expire within 45 days.  I would need to share a list of the tickets  which warranty end date will expire in 45 days.

There is a field in the tasks called: Warranty End date.

I also have a created a filter with the tickets that should do in this list without setting an automation yet.

[Felipe Fernandes]

I did an email notification rule using automation based on due dates. 

In my case, I notify on a slack channel and email all BUGS older than 6 months. I format the result of the query by selecting and then using lookupIssues smart value function: 

{{#lookupIssues}}
> *{{key}}*: {{summary}}
> Link: `{{url}}`
> Criado em: `{{created.format("dd/MM/yyyy")}}`
>
{{/}}

 I hope that it helps in someway.

best

[Vera Valshonok]

Thanks!