Title
Need find script for variable dates
Post
For my table EVENTS I need a script to finds events from 7 days go into the future.
I would prefer to return the results in a Value List, since there will nver bemore than to or three future events on the calendar. However, my client would accept a separate find layout based on the EVENTS table if necessary.
"7 days go into the future"
Do you mean dates from today to 7 days into the future?
To perform a find for that:
Enter Find mode[]
Set field [YourTable::YourDateField ; Get ( CurrentDate ) & "..." & Get ( CurrentDate ) + 7 ]
Set Error Capture [on]
Perform Find[]
To set up a conditional value list based on such a date range, you need a relationship that matches on a date range. One way to do that is this relationship:
MainTable::gDate1 <= Events::EventDate AND
MainTable::gDate2 >= Events::EventDate
gDate1 and gDate2 should be date fields with global storage enabled.