Set dropdown default value to an item with a start date/time closest to current date/time

[manuelmaccou]

I have a number of speaking sessions with a date and time. The user can pick a session in a drop down. I would like the default option in the dropdown element to show the session that is closest to the current date/time. Any ideas how to do that?

Thanks!

[ihsanzainal84]

Have that dropdown default to an appropriate state.

Then have a workflow set the state to the required date (eg. on page load).

[hanan1]

Hi @manuelmaccou !
if the dropdown’s value is filtered (time > current date/time) then the default value should be search for all speaking times where date > current date/time, sorted ascending: first item. The dropdown will only show times in the future starting from the one closest to current time.

[keith]

Correct

[ihsanzainal84]

Whoops my bad, mixed up dropdowns with date time input. @hanan1 's solution better.

[manuelmaccou]

Thank you!