Find date range "a week before today and all future events"
The title sums it up. I need to write a find script that will show records from a week before today's date and all future records.
Enter Find Mode [ ]Set Field [ YourTable::YourDateField ; "≥" & Get ( CurrentDate ) - 7 ]Perform Find [ ]
This works perfectly. How can I also omit records where the field"event status" = Cancelled or Closed. I have tried to add this option but it then only shows cancelled events.
Enter Find Mode [ ]Set Field [ YourTable::YourDateField ; "≥" & Get ( CurrentDate ) - 7 ]new Record/RequestSet Field [ YourTable::Event Status ; "cancelled"]Omit RecordNew Record/RequestSet Field [ YourTable::event Status ; "Closed"]Omit RecordPerform Find [ ]
When in find mode Omit Record works just like clicking the Omit button when performing this same find manually. Omit request should always be created as the last requests used in the find.
Thank you both! Perfect!
Retrieving data ...