+ Start a Discussion
lil_rangerlil_ranger 

Date workflow rule criteria

I'm trying to create a workflow the will notify the case owner when a case hasn't had any activtiy in the last 3 days.

I got this far and I'm stuck on the last activity date.   I was then going to create a task based off of the trigger date.

 

AND(
OR(
ISPICKVAL(Status, 'Open'),
ISPICKVAL(Status, 'Pending Support'),
AND(
$RecordType.Id = '0123000000009yN',
(NOW() - Last_Activity_Date__c)
))

 

 

Navatar_DbSupNavatar_DbSup

Hi,


You have created a custom field on case Last_Activity_Date__c , can you tell me how this field store the last activity value inside this field trigger or by something else???? Well if you have the date value inside this field the try the below formula for reference:


AND(
OR(
ISPICKVAL(Status, 'Open'),
ISPICKVAL(Status, 'Pending Support'),
AND(
$RecordType.Id = '0123000000009yN',
(Datevalue(NOW()) - Last_Activity_Date__c > 3 )
))

 

Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved. 

lil_rangerlil_ranger

We are using a SQL job to update this field.  The field is a custom date/time field.  I tried your formula and I got this error:

 

Error: Incorrect parameter for operator '-'. Expected Number, Date, received DateTime