You need to sign in to do that
Don't have an account?
bhanu_prakash
end date less than start date and actual date need to be between
HI,
I have three fields start__c, end__c and actual_date__c, Iam looking to write validation rule,
1. end date need to be less than start date
2. Start date can't be more than end date.
3. Actual date need to be between start date and end date.
Note: All are date fields and actual date is optional to save record
i have tried it. its not working
I have three fields start__c, end__c and actual_date__c, Iam looking to write validation rule,
1. end date need to be less than start date
2. Start date can't be more than end date.
3. Actual date need to be between start date and end date.
Note: All are date fields and actual date is optional to save record
i have tried it. its not working
IF( ISBLANK(actual_date__c), ( And ( ( start__c > actual_date__c ), ( actual_date__c < End__c ) ) ) , ( And ( ( start__c > End__c ), ( End__c < start__c ) ) ) )
Below should work :
Please let me know for any issues. Thanks.
All Answers
Below should work :
Please let me know for any issues. Thanks.