Show Records between two dates in Form 6i [message #683075] |
Tue, 01 December 2020 01:10 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/06b42bb1d9c7dd3931310cac212d7c22?s=64&d=mm&r=g) |
hissam78
Messages: 193 Registered: August 2011 Location: PAKISTAN
|
Senior Member |
|
|
Dear All,
Requested you to please help to execute the records between two dates.
I have used the following queries in Block Property Where Clause but not working.
WHERE vdate between
select trunc(sysdate + 2,'iw') - 2
FROM sys.dual
AND
SELECT Trunc(sysdate + 2,'iw') + 4
FROM sys.dual
regards,
[Updated on: Tue, 01 December 2020 01:55] Report message to a moderator
|
|
|
|
|