How to filter assets by date within a custom field

[Dimitrios Danampasis]

We have Transportation assets (Drivers and Vehicles) and I want to check if the following is possible with JSM Assets.

My asset schema:

• Vehicles (key,name,created,updated)
• Drivers (key,name,created,updated)
• Assignments (key,name,created,updated, Vehicle, Driver, assignment date)

The process looks like this:

1. Customer submits a request for a trip with a date (the date comes in as the system field Due Date)
2. Agent selects a Driver and a Vehicle in the issue using custom fields (Assets object type)
3. Jira automation creates a record in Assets with the assignment: vehicle, driver, date

Now, in step 2, I want to filter the drivers and vehicles that are available on that particular date, to avoid booking a driver or a vehicle more than once. 

I don't know how to filter this so any help will be much appreciated. Thanks!