Hi, I'm trying to script a search for dates that fall within a certain range in a schedule. For the start date I use >= start date in the date field in find mode, but I can't seem to do anything like: >= startdate and <= enddate in the field.

Here's what I have for a script so far:

Show Custom Dialog Box ["Search Criteria"; "Please enter a start and end date"; UI_Schedule::Global_SearchStartDate; UI_Schedule::Global_SearchEndDate)

Go To Database ["Database - Schedule_DailyEntries"(Schedule_DailyEntries)"]

Show All Records

Enter Find Mode {}

Set Field [schedule_DailyEntries::Schedule_DailyEntries_Date;">= " & Global_SearchStartDate]

Perform Find[]

And it does find the dates that occur after the start date, but do I have to do another search after that to further constrict the found set? Is there any way to have multiple search criteria for one field in a search?

Hi, I'm trying to script a search for dates that fall within a certain range in a schedule. For the start date I use >= start date in the date field in find mode, but I can't seem to do anything like: >= startdate and <= enddate in the field.

Here's what I have for a script so far:

Show Custom Dialog Box ["Search Criteria"; "Please enter a start and end date"; UI_Schedule::Global_SearchStartDate; UI_Schedule::Global_SearchEndDate)

Go To Database ["Database - Schedule_DailyEntries"(Schedule_DailyEntries)"]

Show All Records

Enter Find Mode {}

Set Field [schedule_DailyEntries::Schedule_DailyEntries_Date;">= " & Global_SearchStartDate]

Perform Find[]

And it does find the dates that occur after the start date, but do I have to do another search after that to further constrict the found set? Is there any way to have multiple search criteria for one field in a search?

Hi, I'm trying to script a search for dates that fall within a certain range in a schedule. For the start date I use >= start date in the date field in find mode, but I can't seem to do anything like: >= startdate and <= enddate in the field.

Here's what I have for a script so far:

Show Custom Dialog Box ["Search Criteria"; "Please enter a start and end date"; UI_Schedule::Global_SearchStartDate; UI_Schedule::Global_SearchEndDate)

Go To Database ["Database - Schedule_DailyEntries"(Schedule_DailyEntries)"]

Show All Records

Enter Find Mode {}

Set Field [schedule_DailyEntries::Schedule_DailyEntries_Date;">= " & Global_SearchStartDate]

Perform Find[]

And it does find the dates that occur after the start date, but do I have to do another search after that to further constrict the found set? Is there any way to have multiple search criteria for one field in a search?

Use the range symbol ... between start and end dates in the set field step.

Use the range symbol ... between start and end dates in the set field step.

Use the range symbol ... between start and end dates in the set field step.

Hi,

A range is generally defined using the "..." operator so that the search criteria is gStart...gEnd.

Hi,

A range is generally defined using the "..." operator so that the search criteria is gStart...gEnd.

Hi,

A range is generally defined using the "..." operator so that the search criteria is gStart...gEnd.