• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 262
  • Last Modified:

Formula Wk1, Wk2 etc

I am developing a graph (CR XIR2)

On the X Axis I want to show Wk1, Wk2, Wk3 etc to Wk52

This will be based on a datetime field called Created in the format of 2009-08-19 12:41:22.650 i.e. yyyy-mm-dd hh.mm.ss

Is there a formula I can use to get it into Wk1, Wk2 etc
0
halifaxman
Asked:
halifaxman
  • 3
  • 2
1 Solution
 
mlmccCommented:
Choose the date field s the axis value.
You can then change it to group by weeks

mlmcc
0
 
halifaxmanAuthor Commented:
Thanks I should have stated I need Wk 1 to start on the 03/01/2011

If I choose by week on the X Axis I still have to edit each Axis Label and change it to Wk1, Wk2 etc
0
 
mlmccCommented:
Will that always be the start date or can the user select any start date?

mlmcc
0
 
halifaxmanAuthor Commented:
That will always be the start date
0
 
mlmccCommented:
Try using a formula like this as the week axis

Local Numbervar weekdiff;
weekdiff := DateDiff('w',Date(2011,3,1),{Table1.myDate});
"wk-" & CStr(weekdiff+1,"00")

mlmcc
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now