search/find within a given date-range.

[dervaish]

hello

once again i need your expert help to sort out this issue. i have a table which store appointments for patients. a patient can have more than 1 appointments. so my problem is that i want to find and display only those records where appointments are within a range of 7 days [7 days from today] so that the person who logs into the system can view the list and then call the patients to remind them about their upcoming appointments in the next 7 days. this range will never exceed 7 days and will always be 7 days from today. so all i want is to filter out and show [omit all others] a list of records that have appointments coming up in the next 7 days only.

so how can i accomplish this?..script or no script...doesn't matter.

thanx in advance.

[mz123]

The script could look something like...

Go to Layout (the layout that you want your user to see/print)

Enter Find Mode

Set Field [Date ; Get(CurrentDate) & "..." & Get(CurrentDate) + 7 ]

Perform Find

Sort Records

[dervaish]

thanx for the quick reply and help. i'll try it out later.