Capture To / From Date to report

I need to run a report that not only requires the run date but I need to capture from the and input it into the form after the run date.

Run Date ------ Search Date Range: ------ to ------

The Search Date Range needs to be picked up from the Search Sort list.

HOW? ?

Any help would be most appreciated.

Thank you in advance for your time

Robin Michael
Tryon, NC
WNC

I run a Date Variable in a Dialog script which contains two variables %Begindate and %Enddate. I have a hot key on the menu bar that plays the dialog script. Then in the report I put the First date and Last Date on the report form. This is explained very well in the Tutorial manual for Ver. 4 and 6 in the back. It is called Get dates. I call my dialog script getdates. The date variable is tricky but well worth the time spent. I use it in almost all my databases.

DATE >= CTOD (%begindate) .and. DATE

[Ken L Herrold]

Robin:

Ken Flemming has precisely the best way to do that.

I've attached the dialog script that I've used for years. The difference is it collects the date variables %begin and %end. The 'Continue' button doesn't do anything but when [enter] is pressed [or a single left mouse-click]after enterng the date variables the dialog closes and the script continues. As you know Alpha will keep those variable values for the entire session.

These variables can be inserted into your search-sort using curley braces. Or... you can have the report do the search sort with the 'explicit search' option in parameters.

Your report's calculated fields to display these dates will be 'Startdate' [expr] CTOD(%Begin) ---- 'Enddate' [expr]CTOD(%end).

Hope this gets you moving.

(other) Ken

[Ken L Herrold]

Robin:

I'm not a good communicator. I said "..these can be entered using curley braces..." WRONG!

For the search-sort choose 'expression' and enter those variables as Ken Flemming suggests.I.E. substitute my variable names.

That's better.

(other) Ken

Thank you all for your input. I will now try to set this up so that we can get it to work. If I have trouble - I will be back again.

Thank you again

Robin