• Nikita Ghosh 19
  • NEWBIE
  • 0 Points
  • Member since 2016

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 2
    Questions
  • 10
    Replies
I need a validation rule:

There is a Status field and if Status = Valid AOC than there should be an specific date that should be update in to AOC Expiry Date (Ther is a default value in the AOC Expiry Date, which is 31/12/2016) If the default value is not changed than there should be an error to update a valid date.   
I am using this formula: 
NOT( AND( ISCHANGED( AOC_Expiry_Date__c ),
 ISPICKVAL( Status__c , 'Valid AOC')  ) )

Formula is working good but after changing the date, still I am facing the error. 
Hi

I have created one custom text(Text01__c) field.This field allows  characters [a-z][A-Z] and space bar only.Any formula or validation rule or workflow rule.It not allows numarics [0-9] and special character

Best Regards,
Ramesh