Subtract one list from the other?

Hi Guys.

I’m making a car booking system. The user enters the start and end dates of the booking. When they press ‘enquire’, the system should return a list of unused cars for that date. Currently I have been able to find which cars are being used at the said date. Now I need to subtract that list from the list with all of the cars. That should leave me with the unused cars. I noticed lists have a intersect and merge function, but no difference function. Any ideas guys?

image

This is what I thought should work but to no avail :frowning:

Hey guys… got the answer… posting here for future reference:

image

3 Likes

This topic was automatically closed after 70 days. New replies are no longer allowed.