You are here:
MOD
Returns a remainder after a number is divided by a specified divisor.
Use
MOD(number,
divisor) and replace number with the field or
expression you want divided; replace divisor with the number to use as the
divisor.
Scheduling Example
MOD(3, 3) returns 0
MOD(4, 3) returns 1
MOD(123, 100) returns 23
To prevent users from scheduling meetings on a Saturday or Sunday, use a validation rule to apply a custom date field called My Date.
CASE(MOD(My_Date__c - DATE(1900, 1, 7), 7),
0, 0,
6, 0,
1) = 0This example displays the following error message when the value of My Date is not Monday through Friday: “My Date is not a weekday.”
Did this article solve your issue?
Let us know so we can improve!
