Find if a date is between Start Date and End Date
I have a global date: G_Date.
I have a table, "trips" with with trip_name, start_date and end_date fields.
I would like to find which record (if any) in the "trips" table where G_date is part of the range between start_date and end_date.
If I create a related table linked with "trip_name", and auto create a record for each date within the start_date - end_date range of the parent table, I should then be able to search on that.
It seems there should be an easier way to accomplish this. I would like to just do a find on the trip table, but I can't figure how to do it.
Any suggestions would be much appreciated.