How to add parameter

[r.reddy.galla]

Hi

I have requirement like,

select *from table

where col between 01-JAN-17 and 31-DEC-17

for that i need pass a parameter for daterange like 01-JAN-17 to 31-DEC-17

how can we take single parameter for date range?

or is there any alternative way to pass parameter?

 

Please help us any one if know the solution . thanks.

[mlopez_1]

I always use two parameters and in the query i put:

  $X{[bETWEEN], DATE_FIELD, DATE_PARAMETER_START, DATE_PARAMETER_END}

This works very well, I never use ragen dates but i think that works well too.

Mariano