Pass two Dates to AutoSearch Fields?

edited February 2017 in End User
Hi Team,

In my report I have a Search criteria of Inv.Date Between dd/mm/yy, dd/mm/yy. AutoSearch is Yes.
In the App, Each of the dates is in a text string StartDate & EndDate.
How do I pass the two dates with 'ppR1.AutoSearchFields[0].SearchExpression :=' please?
Regards & TIA,


  • edited February 2017
    Hi Ian,

    If the search operator is BETWEEN, you can simply separate the two date
    values by a comma and they will be processed as the two dates to be used
    in the query.

    Another option is to use report paramters and assign the two dates to
    the Values property.

    Best Regards,

    Nico Cizik
    Digital Metaphors
  • edited February 2017
    Hi Nico,
    Thank you for your reply.
    Ah Ha! Done & Dusted.
    Thank you very much.

This discussion has been closed.