| Available in: both Salesforce Classic and
Lightning Experience |
| Available in: Contact Manager,
Group, Professional,
Enterprise, Performance, Unlimited, Developer, and Database.com Editions |
Date Must Be a Weekday
|
Description:
|
Validates that the value of a custom date field is a weekday (not Saturday or
Sunday). |
|
Formula:
|
|
|
Error Message:
|
Date must be a weekday. |
|
Error Location:
|
My Date |
Date Must Be a Weekend Day
|
Description:
|
Validates that the value of a custom date field is a Saturday or Sunday. |
| Formula: |
|
| Error Message: |
Date must be a weekend day. |
| Error Location: |
My Date |
Date Must Be in the Current Month
|
Description:
|
Validates that a custom date field contains a date within the current month and
year. |
| Formula: |
|
| Error Message: |
Date must be in the current month. |
| Error Location: |
My Date |
Date Must Be in the Current Year
|
Description:
|
Validates that a custom date field contains a date within the current year. |
| Formula: |
YEAR( My_Date__c ) <> YEAR ( TODAY()
) |
| Error Message: |
Date must be in the current year. |
| Error Location: |
My Date |
Date Must Be the Last Day of the Month
|
Description:
|
Validates whether a custom field called My Date is the last day
of the month. To do this, it determines the date of the first day of the next month and then
subtracts 1 day. It includes special case logic for December. |
| Formula: |
|
| Error Message: |
Date must be the last day of the month. |
| Error Location: |
My Date |
Date Must Be Within One Year of Today
|
Description:
|
Validates whether a custom field called Follow-Up Date is within
one year of today’s date. This example assumes a 365 day year. (It does not handle
leap years.) |
| Formula: |
|
| Error Message: |
Follow-Up Date must be within one year of today. |
| Error Location: |
Follow-Up Date |
Day of Month Cannot Be Greater Than 15
|
Description:
|
Validates that a custom field called Begin Date contains a date
in the first 15 days of the specified month. |
| Formula: |
|
| Error Message: |
Begin Date cannot be after the 15th day of month. |
| Error Location: |
Begin Date |
End Date Cannot Be Before Begin Date
|
Description:
|
Validates that a custom field called End Date does not come
before another custom field called Begin Date. |
| Formula: |
|
| Error Message: |
End Date cannot be before Begin Date. |
| Error Location: |
Begin Date |
Expiration Date Cannot Be Before Close Date
|
Description:
|
Validates that a custom field called Expiration Date does not
come before Close Date. |
| Formula: |
|
| Error Message: |
Expiration Date cannot be before Close Date. |
| Error Location: |
Expiration Date |
j