Return to FileMaker.com
search on date ranges automatic
hello I have to do a search in a series of records.the search will be carried out on a date range.I wish I were automatically searched the expiry of the last seven days.seven days then back to the date hereof.As I write the command?thanks
The following script will find records for the last 7 days:
Enter Find ModeSet Field [ Your_table::Your_date_field ; Get ( CurrentDate ) - 7 & "..." & Get ( CurrentDate ) ]Perform Find 
Retrieving data ...