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

Just need data from the weekend 2

Status
Not open for further replies.
porps

porps

Technical User
Joined
Nov 6, 2008
Messages
2
Location
US
Hi everyone!

I'm trying to use the Select Expert to only pull data from an Oracle DB that happened on the weekend. Any hints?

Thanks so much!
 
Sort by date Sort by votes
Function Day() returns day number of week.

day(05/Feb/2009) will retur 5 = Thursday.

In Crystal terms Sataurday is 7 and Sunday = 1.

You can use this to define weekends only

Ian
 
Upvote 0 Downvote
I'm sure Ian means dayofweek(). Day() returns the day of the month.

-LB
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

H
  • Locked
  • Question Question
Cannot get a sub-report to print without the headers and footers of the main report
Replies
1
Views
423
DjangMan
DjangMan
JustMe24
  • Locked
  • Question Question
How to select from 2 rows in a table
Replies
1
Views
717
SoftwareRT
SoftwareRT
tlbrown88
  • Locked
  • Question Question
How to duplicate data from main report lines for sorting purposes
Replies
2
Views
523
lbass
lbass
anandm19
  • Locked
  • Question Question
Crystal report byte array data to Unicode data format export issue
Replies
0
Views
501
anandm19
anandm19
Ajmal N
  • Locked
  • Question Question
Compare a field from main report against a field from a subreport on CRYSTAL REPORT
Replies
7
Views
763
kray4660
kray4660

Part and Inventory Search

Sponsor

Back
Top