Home » Developer & Programmer » Forms » Show Records between two dates in Form 6i (Form 6i, Windows 7)
Show Records between two dates in Form 6i [message #683075] Tue, 01 December 2020 01:10 Go to next message
hissam78
Messages: 142
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

Re: Show Records between two dates in Form 6i [message #683077 is a reply to message #683075] Tue, 01 December 2020 04:09 Go to previous messageGo to next message
Michel Cadot
Messages: 67880
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Just remove "select " and "FROM sys.dual" parts.

Re: Show Records between two dates in Form 6i [message #683089 is a reply to message #683077] Tue, 01 December 2020 12:50 Go to previous message
hissam78
Messages: 142
Registered: August 2011
Location: PAKISTAN
Senior Member
Dear Michel Cadot,
Grateful for you prompt response, Bundle of thanks, It works fine..

best regards,
Previous Topic: D2KWUTIL.PLL make form slow to respond
Next Topic: Passing Parameter node values from one Form to another
Goto Forum:
  


Current Time: Sun Jun 13 15:02:34 CDT 2021