Disply most current date of column in a text box

[alec1982]

hi guys,

I want to display the most current date into a text box giving that i have a date column as follow

Date

05/07/2014

06/01/2014

06/02/2014

07/01/2014

In this case the text box should show 06/02/2014.which is the first date on the column before today's date.

let me know if doable..

Thxs,

Alec

[maxgro · Accepted solution]

=date(max({$<datefield={"<$(=today())"}>} datefield))

[alec1982]

Thxs!