Min(value1, value2, …, valueN)

Returns the minimum value.

Parameters

value:
The value to check. All values must be of the same type as value1. Null values are ignored.

Returns

The result is of the same type as value1.

Remarks

• For Numbers, it returns the least argument.
• For Texts, it returns the argument that sorts first alphabetically.
• For Durations, it returns the shortest argument.
• For Dates, it returns the earliest argument.
• For Timestamps, it returns the earliest argument.
• For TimeOfDays, it returns the earliest argument.
• For Booleans, it returns the smallest argument, treating false as less than true.

Examples

• Min(50, 60, 70, 100) returns 50.
• Min(50, 60, 70, 100, 0) returns 0.
• Min("Jane", "Rita", "Linda") returns "Jane".
• Min(3d, 22h) returns 22h (twenty-two hours).
• Min(#2013-03-22#, #2013-05-15#) returns the date value 2013-03-22.
• Min(ToTimestamp(#2013-03-22#), ToTimestamp(#2013-05-15#)) returns 03/22/2013 00:00.
• Min(ToTimeOfDay("3 pm"), ToTimeOfDay("8 pm")) returns 15:00.
• Min(false, true, false) returns false.