You need to sign in to do that
Don't have an account?
padma
validation Rule
Hi All,
i have problem a validation rule
below is my code :
AND(
OR( ISCHANGED( status__c ), ISNEW()
),
AND( ISPICKVAL( status__c , 'new'),
Activity_Date__c <> TODAY()
))
in this code There is no errors but it will not be worked . why
can any one help ....
Thanks&Regards
i have problem a validation rule
below is my code :
AND(
OR( ISCHANGED( status__c ), ISNEW()
),
AND( ISPICKVAL( status__c , 'new'),
Activity_Date__c <> TODAY()
))
in this code There is no errors but it will not be worked . why
can any one help ....
Thanks&Regards
What was this validation rule supposed to do?
Regards.
1st: it will check the status is chaged;
Yes- go to ExtStep->
No- It will check is it a new record
Yes- go to ExtStep->
No- returns FALSE
ExtStep: It will check is status is 'new' and Activity Date is not TODAY
Yes: returns TRUE
No: returns FALSE
Which states that
For existing record: If Status value is getting changed to "new" and Activity Date is not TODAY, validation rule ll return TRUE
For new record: if Status value is 'new' and Activity Date is not TODAY, validation rule ll return TRUE
-- Make sure that you are doing the same