+ Start a Discussion

Expiration Date must not be more than 10 Business Days from Created Date.

ExpirationDate > TODAY() + 10

Steve :-/Steve :-/

I don't understand, what is the question you're asking?


Using TODAY() will not help because every time a change is made, the system will add 10 days to the current date which could definitely be greater than the Created Date. Try using the following expression as the condition formula:


ExpirationDate >DATEVALUE(CreatedDate) + 10


You have mentioned that you would like the Expiration Date to be not more than 10 Business Days; are you trying to refer to any Business Hours which you may have created in your SFDC org? If Yes, then please keep in mind that Business hours cannot be referenced in Validation Rules or Formula Fields. You will need to use an Apex Trigger to check for the condition.