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!

Weekday versus Weekend

Status
Not open for further replies.
qcman

qcman

Technical User
Jul 20, 2004
30
0
0
US
I need to create a crosstab that counts occurences that happened during the week versus weekends.
 
Sort by date Sort by votes
if dayofweek({table.date}) in 2 to 6 then "Weekday" else
"Weekend"

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

Similar threads

CSADataCruncher
  • Locked
  • Question
Exlcuding Weekends and Holidays with DateDiff
Replies
4
Views
28
CSADataCruncher
CSADataCruncher
qcman
  • Locked
  • Question
Separating Weekdays and Weekends
Replies
2
Views
19
lbass
lbass
porps
  • Locked
  • Question
Just need data from the weekend 2
Replies
2
Views
10
lbass
lbass
helphelen
  • Locked
  • Question
Need to calculate total days less weekends 1
Replies
2
Views
19
lbass
lbass
puddinpop
  • Locked
  • Question
How to report surgical cases that occur after hours and on weekends 1
Replies
2
Views
17
puddinpop
puddinpop

Part and Inventory Search

Sponsor

Back
Top