Dates and sorting

[wmehner]

Hello,

I want to create a report that takes a date and sorts it by a range (like 3/1/2007...3/31/2007) and sort it. Sounds easy, but I want it to prompt the user for the date range. (popup window) Is this possible. I'm trying to create a one click and click OK, then it creates the report. I can't figure out how to script this? Any help..

[aldipalo]

In script Dialog, under Miscellaneous>Show Custom Dialog.

HTH

[wmehner]

Thanks, but for some reason I can't get the script to just limit it to the date range. This is the script that I have:

- Go to layout["CSBD"(Contacts]

- Enter Find Mode [pause]

- Show custom Dialog["enter dates";"enter dates in this format 1/1/2007...1/31/2007"; Contacts::CSBD]

- sort records [restore;No dialog]

- enter preview Mode [pause]

- enter browse mode []

- go to layout [original layout]

The script runs but gives all records not the ones requested in the custom dialog. Any clues as to what I'm doing wrong..

[LaRetta]

I see no Perform Find before the sort?

[wmehner]

Thanks for your observation. I have it fixed. Thanks.