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!

Separating Weekdays and Weekends

Status
Not open for further replies.
qcman

qcman

Technical User
Jul 20, 2004
30
0
0
US
I want to count how many occurences happened from monday to friday and how many occurences on the weekend.
 
Sort by date Sort by votes
Sorry, didnt realize I posted thread earlier.
 
Upvote 0 Downvote
if dayofweek({table.date}) in 2 to 5 then
"Weekday" else
if dayofweek({table.date}) in [1,7] then
"Weekend"

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

Similar threads

nicmcd77
  • Locked
  • Question
Legend resizing and overlapping onto chart
Replies
2
Views
73
nicmcd77
nicmcd77
crystaldev1
  • Locked
  • Question
Sorting a field by combining main and subreport
Replies
3
Views
45
hilfy
hilfy
mart10
  • Locked
  • Question
Charts and showing parameter values selected
Replies
7
Views
56
mart10
mart10
mart10
  • Locked
  • Question
number to date - ordering and charting
Replies
2
Views
66
mart10
mart10
Marco Poblete
  • Locked
  • Question
how to save the value of column from the first record to a global variable and use it later?
Replies
18
Views
173
Marco Poblete
Marco Poblete

Part and Inventory Search

Sponsor

Back
Top