Limit data to date range.
?I am trying to set a specific date range for a report but not simply by
specifying start and end dates. I need to be able to limit the data
returned by a "date selected" - 90 days limit. Basically only one date
prompt and return all data from the date back 90 days.
Do I need to calc the data - 90 value or is there some better way to do
it. I want only one user data prompt, the date back from which we query.
--- posted by geoForum on http://delphi.newswhat.com
specifying start and end dates. I need to be able to limit the data
returned by a "date selected" - 90 days limit. Basically only one date
prompt and return all data from the date back 90 days.
Do I need to calc the data - 90 value or is there some better way to do
it. I want only one user data prompt, the date back from which we query.
--- posted by geoForum on http://delphi.newswhat.com
This discussion has been closed.
Comments
I would suggest creating an autosearch criteria that sets up the date range
on the fly. You could use the OnGetAutoSearchValues event to get the
initial date, then using the SQLBuilder (see TdaSQLBuilder in the
RBuilder.hlp) you could create the date range in your query.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com