date ranges

[qwertyu1]

hello all,
iam using crystal xi and oracle 9.

i have a one database date field.

on that i have to create parameters like start_date and end_date.
(i.e user has to enter these two dates.)

how can i create paramter fields on this field.
help requested.

 

[GJParker]

Create a date range paramater call it date_range, set the type to date and in the options set Allow range values to True.

Then simply use this in your record se;ection formula i.e.

{MyTable.DateField} In {?date_range}

HTH

Gary Parker
MIS Data Analyst
Manchester, England