You are here: Record management > Building expressions with the Expression Builder > Expression evaluation > Multiply, divide, and remainder operations

Multiply, divide, and remainder operations

This table shows the valid combinations of types when the operator is *, / or %. To understand the calculation of the expression A * B, find the intersection of the row for A's type and the column for B's type. Consult the numbered notes for the details of casting or conversion.

DateTime

Date

Time of Day

Integer

Decimal

Double

True or False

Other (text)

DateTime

X

X

X

X

X

X

X

X

Date

X

X

X

X

X

X

X

X

Time of Day

X

X

X

X

X

X

X

X

Integer

X

X

X

1

1

1

X

X

Decimal

X

X

X

1

1

1

X

X

Double

X

X

X

1

1

1

X

X

TrueFalse

X

X

X

X

X

X

X

X

Other (text)

X

X

X

X

X

X

X

X

Notes for multiplication, division, and remainder operations: