You want to search for a date range.
How do I write a script that finds a range of dates in FileMaker Pro?
Answer ID: 5912Last Updated: Jul 20, 2012
Go to Layout ["Layout #1"]
Enter Find Mode 
Set Field [<TableName>::aDate ; [<TableName>::Start Date & "..." & [<TableName>::End Date]
Perform Find 
$$Date1& "..." & $$Date2
Thanks David, that worked, in fact, since I always need a week period, I use a dropdown calender for the start date, then calculate the end date as (Startdate + 7)