Developer 2000 Create_Group_From_Query

hello all;
  I am using developer 2000 with forms 4.5.7.1.6 and need some help with the Create_Group_From_Query function.

I am trying to have Create_Group_From_Query parse a statement similar to this  'Select f1,f2,f3,f4, date_field from table where date_field between daterange1 and daterange2'

daterange1 and daterange2 come from the user. I get them and concatenate them to the sql string using the ||. I have tried the dates with quotes and without quotes and in different formats.
The sql statement works from within sqlplus however it does not work with the Create_Group_From_Query. If i take of the where clause it works or if i change the the date_field part of the where clause to something else it works.

What i am asking in a round about way is has anyone encountered a problem like this with forms and if so what did you do ?

thanx ahead of time

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Mar 25 1998 - 00:00:00 CST