Infopath get max() value from SharePoint column

How can I get the max value (the row with the开发者_如何学运维 greatest value for a particular column) from a SharePoint document library using Infopath and the Document Information Panel.

Tried max(.) it does not work.

Thanks.

I tried this as well in Infopath but was unable to do so. In the end I was forced to write VSTA code for the infopath form, query the form, then executed a CAML query to get the max entry:

<View>
    <Query>
        <OrderBy>
            <FieldRef Name="yourColumn" Ascending="FALSE" />
        </OrderBy>
    </Query>
    <RowLimit>1</RowLimit>
</View>