Home Search

DriveWorks Pro 22
DMin

Send Feedback

DMin

Returns the smallest value in the given table's column which complies with the specified condition.

Syntax

DMin([Table or Table Name],[Column Index],[Condition], [Ignore Whitespace])

Where:

Table or Table Name is the table to search in.

Column Index is a number representing the index of the column in the table.

Condition is the condition to test each cell in the column with.

Ignore Whitespace (optional) is True to ignore leading/trailing whitespace characters in text strings in the condition, otherwise False.

Examples

Rule

Meaning
DMin(DwLookupDataTable,1,"<10")This will look in the table DataTable, in column 1 and return the smallest value that is less than 10.