Home » Developer & Programmer » Forms » building default_where string containing date values
building default_where string containing date values [message #78944] Fri, 05 April 2002 03:35 Go to next message
Stephen Agbodza
Messages: 4
Registered: February 2002
Junior Member
Hi folks,

i am trying to query a block by building a default_where string in the ff format

requested_from = <value1> and request_date between <date1> and <date2>

value1 is a varchar2, date1 and date2 are in the format dd-mon-yyyy.
All values are entered in the form.

I am at a loss. Please help.
Re: building default_where string containing date values [message #78950 is a reply to message #78944] Fri, 05 April 2002 19:18 Go to previous message
rama krishna
Messages: 97
Registered: December 2001
Member
set_bloc_propert('block_name',default_where,'requested_from ='||''''||value1||''''|' and request_date between '||to_date(date1'dd-mon-yyyy)||' and '||to_date(date2'dd-mon-yyyy)

hope this will work. the character should be always put in quotes. and try always use to_date with dates...

cheers
ram
Previous Topic: Problems getting LOV to open up
Next Topic: D2K form design issue
Goto Forum:
  


Current Time: Fri Apr 03 06:23:30 CDT 2020