How to add parameter

0

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.

r.reddy.galla's picture
Joined: Apr 24 2017 - 5:52am
Last seen: 2 weeks 1 day ago

1 Answer:

0

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

mlopez_1's picture
547
Joined: Oct 21 2013 - 8:08am
Last seen: 1 day 14 hours ago
Feedback
randomness