Date Range Search

[Young Padawan]

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?

[Young Padawan]

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?

[Young Padawan]

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?

[RalphL]

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

[RalphL]

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

[RalphL]

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

[Ugo DI LUCA]

Hi,

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

[Ugo DI LUCA]

Hi,

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

[Ugo DI LUCA]

Hi,

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