Specifying your days in a year in weeks 1

[TryingToLearn101]

Hi all,

I know I can grouped my dates and get them in groups by the week. However, what I need is to get the information to say week 1, week 2, week 3, etc for all the days in the year. My ultimate goal is to be able to compare week 1 of this year vs. week 1 of last year.

I don't really care if this year's week 1 consists of 3 days and last year 4 days - As long as they are within the same week 1 then I want to compare them. I know how to do the comparison but I don't know how I can assign such and such date of the year is week 1 or week 2 or week 3.

I hope I am explaining this clear enough.

I am currently on Crystal XI Professional. Any guidance is greatly appreciated. Thank you in advance.

 

[lbass]

You can use a formula like this:

"Week "+datepart("ww",{table.date})

You can also add a condition that specifies which is the first week. Read up on this in the Help files->datepart.

-LB

 

[TryingToLearn101]

This is exactly what I need. Thanks again lbass.