ArdeviaForum

Minimum Sub-List item value - Minimum Sub-List item value

Discussion created by ArdeviaForum on Aug 19, 2016
Latest reply on Aug 19, 2016 by ArdeviaForum

Original Post by Sandy (Imported from Ardevia Forum)

Hi,

 

I have a Travel Requisition form that consists of the Travel Requisition List and 3 sub-lists, Flights, Accommodation and Car Hire. Each of these 3 sub-list items has a start date entered by the user but I need to find the earliest date out of all the items entered in those sub-lists to determine the travel start date.

 

Flights

 

AKL-BNE 01/09/2016
BNE-AKL 10/09/2016

 


Car Hire

 

BNE 01/09/2016
CNS  04/09/2016

 

Accomm

 

BNE 01/09/2016
CNS  04/09/2016

 


Although several of these items will return me the minimum date, I need to check the minimum for each sub-list to be sure I get the earliest date.

 

Is this possible?

 

Thanks Sandy

Outcomes