help in function in parameters

[amz]

Hi,

Is it possible to include function in date parameters?

order_date between &
and &

How can I include to_date on the parameter like to_date('01/01/2009', 'dd/mm/yyyy')?

thanks

 

[Theod]

Hi,

in sql-windows this works, should also for reports.

...
order_date between to_date('&','dd/mm/yyyy')
and to_date('&','dd/mm/yyyy')