Can someone help me to achieve two things :
1) i have a dataset where i want to highlight circular name where circular close date is not within 15days of circular issue date.
(Circular close date should be within 15 days of circular issue date)
2) i want to create an email alert for the same workflow where 15days is crossed and prior to that one email alert to update that deadline is about to breach . Eg: 13th day i should receive an alert to say please close the circular.
and if its still not done the 16th day it will be sent to the team lead stating defaulter .
i have attached data set for the refernce
Circular close date should be within 15 days of circular issue date