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

Group by date - weekly

Status
Not open for further replies.
koolskins

koolskins

IS-IT--Management
Nov 22, 2003
79
US
Running CR10 and have a number of charts showing data values by week. The default layout appears to use the week beginning date on the y-axis. How do I make this display the week ending date instead?

Rw
 
Sort by date Sort by votes
For your date group, use a formula:

{table.date}-dayofweek({table.date})+7

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

Similar threads

T
  • Locked
  • Question
Date comparison Formula
Replies
2
Views
2K
TPG_IT
T
D
  • Locked
  • Question
Comparing two Date Ranges
Replies
0
Views
451
doodledump
D
cursedkorok
  • Locked
  • Question
Group consecutive dates
Replies
12
Views
868
pmax9999
pmax9999
PJ222
  • Locked
  • Question
is date within any date range in a dynamic array of date ranges
Replies
1
Views
329
PJ222
PJ222
jlr123
  • Locked
  • Question
date range group by month 1
Replies
8
Views
444
jlr123
jlr123

Part and Inventory Search

Sponsor

Back
Top