Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Record Selection

Status
Not open for further replies.

CPK6104

IS-IT--Management
Dec 19, 2007
57
US
I'd like to use two date ranges in a record selection statement. In the end, I'd like to bring in records with a date range of 1/1/07 - 7/31/07 and 1/1/08 - 7/31/08. It would be nice if it were as simple as this:
{INCIDENT.START_TIME} = ({?2007 Date Range}and{?2008 Date Range})

Is it possible to bring in records using two date ranges?

Thank you.
 
You could use:

(
{INCIDENT.START_TIME} = {?2007 Date Range} or
{INCIDENT.START_TIME} = {?2008 Date Range}
)

...if you want to use separate parameters. You should probably be posting in forum767 or forum149.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top