Hello All.
I am looking for an agent that will send an email to 1 person if the Termination date is less than 90 days from today’s date.
This is what I have so far…
@If(@Date(TermDate) >90 ; @Date(DateField)=NULL; @MailSend(…));
SELECT Form = “Vendor Contact” & @Today = @Date(DateField)
Thank you for the help!!!
Mary 