Data Alert when Deadline Approaching (Gantt Chart)

Hello,

I need to create some sort of alert/ email sent out when the duration of a task is less than 3 months (90 days). I know that data alerts can only be created based on KPI, cards, and gauge visuals- but is there any way around this? I would be willing to try anything for this to work!

Thank you