Using today's date as criteria?

rbuser

Hi

RB7, how do I create a statement in the end-user facility that only selects
records where the field date is less than TODAY'S date. I prefer this to
happen automatically, or alternatively if the user needs to enter criteria
selection when running the report, how would I automatically insert today's
date as the default?

Thanks

Alex

nardmoseley

Try this..

- create an AutoSearch criteria for the report
- use the BeforeAutoDialogCreate event to set the
Report.AutoSearchFields[].SearchExpression to the date. You will need to
convert todays date to a string
- optionally set the Report.ShowAutoSearchDialog to false to suppress
showing the dialog to the end-user



--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com