I am trying to get some workflow rules sorted and I need one that meets the following criteria,
I want it to look at next maint date, and trigger 15 days before and then I want it to look at check box water meter service included and if true, trigger an email
AND((Next_Maintenance__c -15=TODAY()),
(Water_Meter_Service_Included__c,1,FALSE))
I am obviously doing something wrong here as I keep getting my fav error (THE MISSING ")" ERROR)
Thank you very much in advance :-)
Jess P
4 answers
I have question following the response. I know SFDC workflow time triggers don't support seconds or minutes, but is there a way to cutomize them programtically?
