Pass two Dates to AutoSearch Fields?

rbuser

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,
Ian

nicocizik

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.

--

rbuser

Hi Nico,
Thank you for your reply.
Ah Ha! Done & Dusted.
Thank you very much.

Regards,
Ian