You need to sign in to do that
Don't have an account?

Formula for date-field update
I need some help with my workflow rule formula. Idea is when this Installation Completion date is once set and if someone changes the date after that I'll get an email alert that this field is updated.
Now I've made the email templates,alerts and started working on my workflow rule and this is what I've come up :
AND(ISCHANGED(Installation_Completion_Date__c))
and evaluation criteria is : Evaluate the rule when a record is created, and every time it’s edited
but I'm not sure how to put this part that alert goes off only when it has a date(old value) and the date changes(new value). Now whenever I put date to the field (even when I set the value for the first time) it sends me the email.
Now I've made the email templates,alerts and started working on my workflow rule and this is what I've come up :
AND(ISCHANGED(Installation_Completion_Date__c))
and evaluation criteria is : Evaluate the rule when a record is created, and every time it’s edited
but I'm not sure how to put this part that alert goes off only when it has a date(old value) and the date changes(new value). Now whenever I put date to the field (even when I set the value for the first time) it sends me the email.
you can try:
AND(ISCHANGED(Installation_Completion_date__c),
NOT(ISBLANK(PRIORVALUE(Installation_Completion_date__c))))
All Answers
Regards,
Satish Kumar
ISCHANGED(Installation_Completion_Date__c)
)
I tried putting the PRIORVALUE but it gives me this : Error: Incorrect parameter type for function 'AND()'. Expected Boolean, received Date, so what should I do? I can'y change date field to text.
you can try:
AND(ISCHANGED(Installation_Completion_date__c),
NOT(ISBLANK(PRIORVALUE(Installation_Completion_date__c))))