Creating an active list that changes based on a form's input

[blauer1]

I have created a form for internal sales to fill out for customer pilots.  The form has a lot of customer data plus two important inputs - the start date and end date (pilot_start_date) & (pilot_end_date) of the pilot.  I have also created a list called "Current Pilots" that shows all of the pilots that are active at any given time.  The list is set up to show the company name, contact, etc.

Is there a way to automate my list so that only the current customer pilots that are underway populate the list?

I have tried multiple configurations and nothing works.  

Thank you!

[karstenkoehler · Accepted solution]

Hi @blauer1,

Assuming that both are date properties, yes. Simply filter for "Start date is more than 0 days ago AND End date is more than 0 days from now".

Best regards!

[blauer1]

Brilliant, Karsten!

Thank you!