Comparing values in all the rows in aggregate

Can I confirm that the values that passes only compares to the top row of the aggregate? 

eg. that I had various Start and End date in an aggregate. 

I would like to compare if my new input of start and end lies in between any of the datas.

I managed to compare the values in the top row but not the below. are there any way to compare all data in the aggregate?

For simplicity, it is leave application. Would like to set a logic to provide an error if the employee had already applied for leave.

Thank you!



You can do a for each on the list returned by aggregate and compare inside the for each with the current.

Or you can modify the aggregate to have a filter with your start date and end date. 


Abílio Matos 


Got It... thank you!