I have a lookup field where I want to select ONLY the most recent record that fits certain criteria. For example, if a customer renews their service plan, I may have two records that filter to 

[Customer_Name == input.Customer_Name && Transaction == "Purchase Service Plan"]

and I'd like to select the one with the most recent Date.

Is there a way to do this?
Thanks,

Elizabeth