Show Records between two dates in Form 6i [message #683075] |
Tue, 01 December 2020 01:10 |
|
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
|
|
|
|
|