Query ASK AT RUNTIME date range

kwokm67 · Post by **kwokm67** » Thu Nov 12, 2009 10:57 am

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 · Post by **BobK** » Thu Nov 12, 2009 1:15 pm

Yes it is possible.

Just have two where clauses

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

kwokm67 · Post by **kwokm67** » Thu Nov 12, 2009 1:24 pm

Thanks for the quick response.

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

BobK · Post by **BobK** » Thu Nov 12, 2009 1:30 pm

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 · Post by **BobK** » Thu Nov 12, 2009 1:45 pm

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

kwokm67 · Post by **kwokm67** » Thu Nov 12, 2009 3:29 pm

Many, many thanks!

kwokm67 · Post by **kwokm67** » Thu Jan 21, 2010 11:47 am

Hi Bob,

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

Many thanks,

Kwok

tford · Post by **tford** » Thu Jan 21, 2010 1:41 pm

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 · Post by **BobK** » Thu Jan 21, 2010 2:53 pm

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 · Post by **tford** » Thu Jan 21, 2010 2:56 pm

Good idea Bob. Thanks for sharing it.

kwokm67 · Post by **kwokm67** » Thu Jan 21, 2010 5:12 pm

Thank you both very much.