Hello all,
I have a list of vehicles and in that list is a column called vehicle status and the choices are available and unavailable. I use this line to filter the Available vehicles in my form, this is to keep customers from checking out a vehicle that is already checked out on those days,
The way it should work the customer puts in his two dates, it is then sent to a SharePoint library where there are a list of previous vehicle checkouts. It should read down the column that has the pickup dates and read down the column that has return dates. If it finds dates that meeet the criteria the workflow should mark the vehicle as available.
This would then send the list of available vehicles to the form for the customer to check out. My problem is that I am unable to get Infopath nor Sharepoint to do the proper search and return the list of available vehicles.