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 gkittelson 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
May 29, 2007
5
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
Running total from a subreport only showing last value
Replies
4
Views
514
doodledump
D
J
  • Locked
  • Question
New page before when a detail section last on page.
Replies
1
Views
385
hilfy
hilfy
Cpreston
  • Locked
  • Question
Only Select certain rows 1
Replies
7
Views
384
Cpreston
Cpreston
mmck1964
  • Locked
  • Question
Using "OR" to select data
Replies
4
Views
394
mmck1964
mmck1964
B
  • Locked
  • Question
Difference of a field between 2 variable dates
Replies
1
Views
188
hilfy
hilfy

Part and Inventory Search

Sponsor

Back
Top