How to identify a range of dates in a script?

[cdr-dev]

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

[-Queue-]

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

[cdr-dev]

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?

[-Queue-]

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.