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})
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})