Function: Mod
Description
Returns the remainder after dividing number1 by number2.
Syntax
Mod(number1,number2)
Arguments
number1 is the dividend (i.e., the number or numeric expression) that is divided by number2.
number2 is the divisor (i.e., the number or numeric expression) by which number1 is divided.
Return value
This function returns a numeric value.
Calculated field example
If the Minutes field contained the number 32446, and the outstanding minutes past the particular hour is required, the following calculated field expression would return the value 46: Mod(Minutes,60)
Filter/Find example
Records in which the Minutes field value is equal to 46 past the hour can be found with: Mod(Minutes,60)=46
© 2024 Altair Engineering Inc. All Rights Reserved.