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!

Weekday versus Weekend

Status
Not open for further replies.
qcman

qcman

Technical User
Jul 20, 2004
30
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
91
CSADataCruncher
CSADataCruncher
qcman
  • Locked
  • Question
Separating Weekdays and Weekends
Replies
2
Views
44
lbass
lbass
porps
  • Locked
  • Question
Just need data from the weekend 2
Replies
2
Views
33
lbass
lbass
helphelen
  • Locked
  • Question
Need to calculate total days less weekends 1
Replies
2
Views
61
lbass
lbass
puddinpop
  • Locked
  • Question
How to report surgical cases that occur after hours and on weekends 1
Replies
2
Views
34
puddinpop
puddinpop

Part and Inventory Search

Sponsor

Back
Top