Your_lexical_variable : ' DBTABLE.columnname BETWEEN ' || '''' || :FROM_DATE || '''' || ' and ' ||'''' || :TO_DATE || ''''

hope this helps

regards

Santosh M

09356628950

To use a lexical parameter in the query of your data model prefix it with a '&' (ampersand)

example SELECT ename FROM emp WHERE &lp_lexical_val

The value of p_lexical_val may be set in the code in a trigger etc. as follows:

:lp_lexical_val : 'empno 1111';

or

:lp_lexical_val : 'empno '||:p_input_val;

where p_input_val may be a report input parameter.

1) create P_from_date and P_to_date are user bind parameters

2) Create LP_WHERE_CLS lexical parameter.

3) Write below code in the After Parameter Form Trigger

If :p_from_date is not Null

and :p_to_date is null then

LP_WHERE_CLS : 'AND inv.invoice_date :p_from_date'

elsif :p_to_date is not null and

:p_from_date is null then

LP_WHERE_CLS : 'AND inv.invoice_date :p_to_date'

elsif :p_to_date is not null

and :p_from_date is not null

LP_WHERE_CLS : 'AND inv.invoice_date Between :p_from_date AND :p_to_date '

end if;

This solution may help user more