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 Mike Lewis 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
Nov 6, 2008
2
0
0
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

JustMe24
  • Locked
  • Question
How to select from 2 rows in a table
Replies
1
Views
90
SoftwareRT
SoftwareRT
tlbrown88
  • Locked
  • Question
How to duplicate data from main report lines for sorting purposes
Replies
2
Views
82
lbass
lbass
anandm19
  • Locked
  • Question
Crystal report byte array data to Unicode data format export issue
Replies
0
Views
71
anandm19
anandm19
Ajmal N
  • Locked
  • Question
Compare a field from main report against a field from a subreport on CRYSTAL REPORT
Replies
7
Views
135
kray4660
kray4660
Ajmal N
  • Locked
  • Question
Compare a field from main report against a field from a subreport on CRYSTAL REPORT
Replies
5
Views
98
dgillz
dgillz

Part and Inventory Search

Sponsor

Back
Top