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!

Schedule report to run only peak times every day

Status
Not open for further replies.

tdrBates

MIS
Nov 22, 2002
60
US
I need a report or two reports that is scheduled to run from InfoView at 9:30am and 6:30am

The Schedule report that runs at 9:30am would only pull records from 6am to 9am.
The Schedule report that runs at 6:30pm would only pull records from 3pm to 6pm

Below are two forumulas I used to Schedule an entire day but can I adjust the formulas below to pull in just peak times (i.e. 6am to 9am) and (i.e.3pm to 6pm)?

Formula for @endDate
If cDate({?endDate}) = Date(1900, 1, 1) then
CurrentDate-1
else
cDate({?endDate})

Formula for @startDate
If cDate({?startDate}) = Date(1900, 1, 1) then
CurrentDate - 2
else
cDate({?startDate})
 
Sorry I meant:

I need a report or two reports that is scheduled to run from InfoView at 9:30am and 6:30pm every day.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top