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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Group on 30 minutes. 1

Status
Not open for further replies.
rune

rune

Technical User
Aug 9, 2000
15
NO
It is easy to group on 60, 15 and 5 minutes, but I need to group my in 30 min intervals, howe can I do that on a "Date/Time" field?
 
Sort by date Sort by votes
Group on the following field:

truncate( DateTimeToSeconds ({yourDTfield}) / 1800) Ken Hamady
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

bbranco
  • Locked
  • Question
Query Help - Group By 2 tables
Replies
0
Views
408
bbranco
bbranco
SarahSCPDAdmin
  • Locked
  • Question
Crystal Reports - Group question 1
Replies
2
Views
577
SarahSCPDAdmin
SarahSCPDAdmin
G
  • Locked
  • Question
Multiple groups in same level
Replies
0
Views
166
george1610
G
Kennymc
  • Question
Has anyone used Crystal reports with online Microsoft Dynamics 365
Replies
0
Views
105
Kennymc
Kennymc
Corinne30
  • Locked
  • Question
Duplex Printing of Postcard reminders - Not printing back on last page.
Replies
1
Views
422
hilfy
hilfy

Part and Inventory Search

Sponsor

Back
Top