Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=date(max({$<datefield={"<$(=today())"}>} datefield))
=date(max({$<datefield={"<$(=today())"}>} datefield))
Thxs!