I am about wiped out trying to figure out the easiest way to do this. Here is what I am trying to accomplish.

I have a layout that is for scheduling appointments and I want to view dates that are available by viewing the schedule from todays date, on forward. I want the user to find open dates even if they are scheduled up to 6 months later.

They view the schedule in a columnar report that lists dates/times.

How can I setup a script to where when they click a button, that it will run the script and show all dates/times that are scheduled and not leave any out and display the results in a columnar report?

Many thanks!

Chris

How about

Allow User Abort [Off]

Set Error Capture [On]

Enter Find Mode [ ]

Set Field [datefield; ">=" & Get(CurrentDate)]

Perform Find [ ]

If [Get(FoundCount)]

Go to Layout [report]

Else

Show Custom Dialog ["There are no scheduled dates for today or afterward."]

Show All Records

End If

The Set Field line appears to be having some problem determining the current date with future appointments that are entered. ScriptMaker sets the line up as

Set Field[Appointments::Apptdate; " > = "& Get ( CurrentDate )]

Is the format of the line, the problem, or do I have some other consideration to look at?

You need to remove the spaces around >= or use the 'greater than or equal to' symbol located in the Operators list, or the find will fail due to invalid criteria.