Re: Date QBE search - Forms 6i

Hi

I'm not a forms 6 developer, but I've used Oracle Apps 11.5 enough to know the old 'substitution variable' trick still works.

1. In Enter Query mode, put a substitution variable, e.g.:

&X

{It doesn't have to be an X, it could be any letter or word you like. What matters is the &}

2. Press Execute Query

3. A window will pop, titled something like 'Query Where...'

4. Enter something like:
&X between <date1> and <date2>

Hope I understood your problem correctly, and that this response helps...

Clive

PS I'm surprised you can't use '>' or '<' when querying the date field. I seem to remember previous versions of forms allowing it...

Michael J. Moore <mNiOcShPaAeMl.j.moore_at_wcom.com> wrote in message news:7bDo5.568$6a1.10083_at_pm01news.wcom.com...
> Hi,
> I have a date field that I use for a QBE search. I'd like to be able to
> specify a range of dates to be returned. Or if I can't do that, at least
> say, "return only dates greater than ..." For numeric data I can use the >
> sign in the QBE, for example >1234
> How can I do the same sort of functionality for a date field?
> Thanks,
> Mike
>
>
Received on Wed Aug 30 2000 - 00:12:19 CEST