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!

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

Pull only the Last Hour of Data 1

Status
Not open for further replies.
rhollet

rhollet

Technical User
Joined
May 29, 2007
Messages
5
Location
US
Hi,

I need to be able to pull only the last hour of tickets in Crystal Reports 2008. Can anyone tell me what formula to use in select expert?
 
Sort by date Sort by votes

Remember that you can pass in a negative value to dateadd to go back in time:


yourdatetimefield >= dateadd("h",-1,currentdatetime)

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

D
  • Locked
  • Question Question
Running total from a subreport only showing last value
Replies
4
Views
1K
doodledump
D
tlbrown88
  • Locked
  • Question Question
How does one get the results of a Calculation (SharedVar) on the same line as the Sub Report?
Replies
4
Views
971
tlbrown88
tlbrown88
J
  • Locked
  • Question Question
New page before when a detail section last on page.
Replies
1
Views
853
hilfy
hilfy
Cpreston
  • Locked
  • Question Question
Only Select certain rows
Replies
7
Views
989
Cpreston
Cpreston
mmck1964
  • Locked
  • Question Question
Using "OR" to select data
Replies
4
Views
1K
mmck1964
mmck1964

Part and Inventory Search

Sponsor

Back
Top