Generating daily report/specific date report
I'm fairly new with file maker. Current i'm working on a system for a tour company to manage tour reservation.
For each tour, i've assign the tour start date- end date, the duration ranges from day trips to 2 weeks trips.
I'm trying to generate a daily tour report to see what on each day.
Ideally is a find function where i can enter any date ,
the result will be list of trips matching seached date ie. the searched date falls between the tour start date and end date(tour duration date range)
thanks in advance