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