Query ASK AT RUNTIME date range

kwokm67

Is it possible to ASK AT RUNTIME in a Query for a date range?

For example dates between 01/01/2009 to 12/01/2009?

If this is covered elsewhere in the forums please point me to the right direction.

Many thanks.

BobK

Yes it is possible.

Just have two where clauses

Order.EnteredDate >= (Ask at run-time) AND
Order.EnteredDate <= (Ask at run-time)

kwokm67

Thanks for the quick response.

I thought that is all I need to do but I only get prompt once for the date.

BobK

It has been awhile since I did this and I forgot to mention the following:

After doing the above, go to the 'Rule Form' tab.
It should display something like:

FIND DateSearches WHERE DateSearches.EndDate<=?'End Date' AND DateSearches.EndDate>=?'End Date'

Change it to something like (change in bold):

FIND DateSearches WHERE DateSearches.EndDate<=?'Start Date' AND DateSearches.EndDate>=?'End Date'

I just guessing, but I think you need two different values for the labels.

BobK

Excuse the typo. I got the '<=' and '>=' in the wrong order in the above example.

kwokm67

Many, many thanks!

kwokm67

Hi Bob,

I would like the "From Date" and "To Date" to appear on my report heading. Is this possible?

Many thanks,

Kwok

tford

That would be a bit more complicated, but possible.

1) Use attributes in RegularUser BO

2) When running a process to print the reports, have a form that allows input of the dates in the RegularUser BO

3) Use the RegularUser attributes on the query that generates the report & in the title are of the report.

BobK

I solved this problem by basically doing what Tom suggests.

The only difference is that I do not like clogging up the RegularUser BO with attributes that are not needed by the RegularUser. I have a MiscObject BO that I use for these types of attributes. Since my MiscObject is not needed after the process that creates the report, the Persistence is set to 'Not persisted'

tford

Good idea Bob. Thanks for sharing it.

kwokm67

Thank you both very much.