I need to get the maximum date from a list of selected items in a combo box.
This:
Sort(ComboBox1.SelectedItems.'End Date','End Date',Descending).'End Date'
Gives me a one column table of the dates which I can make show up properly in a list box. When I apply the First function like this:
First(Sort(ComboBox1.SelectedItems.'End Date','End Date',Descending).'End Date')
I end up with what looks like a date serial number in the list box. The resulting data type is a record with a Name and Value field. Attempting to access the value like this:
First(Sort(ComboBox1.SelectedItems.'End Date','End Date',Descending).'End Date').Value results in an error "Name isn't valid. 'Value' is not recognized". I am sure that I am missing something obvious here but I can't seem to figure this out. Any help is appreciated.
