DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

data between 'from date' and 'to date'

PERCY2May 8 2008 — edited May 14 2008

Hi All,

I have one situation,I've one table which contains 2 date columns ,

1. from date
2. to date

Now I'm building one report based on this table & I've given user
search criteria based on two dates (date range) i.e. v_date_from and v_date_to through parameter form.

I'm trying to write a query which will return me the rows between date range v_date_from and v_date_to using "BETWEEN AND" but its not at all working...

I want to get data from table for this date range...

I'm using :

Report Builder 6.0.5.28.0
ORACLE Server Release 8.0.5.1.0
Windows 2000 server

I hope i've mentioned problem clearly...

Any help ?

Regard's

Percy