Parameter Range for Date

[Steveie]

Does anyone know how to do date range using the between function in select expert. I can get the is equal to work but when I select between parameter it is not there.

 

[Soleil525]

You can create two parameters: start and end. Don't use select expert. Do it through Report, Edit Selection Formulat, Record then enter this code:
{datefield} in {?start} to {?end}

 

[dgillz]

also, you can create one parameter instead of 2, and make it a date range parameter. To display this parameter on your report header, write a formula:

totext(minimum({?DRParm}))+" to "+totext(maximum({?DRparm})) Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office