Rajesh

Interesting...is the split-by Week field definitely data-typed as Date/Time? What happens if you change the date format to something different?

Could you send us a (text scrambled) version of the file with just a few weeks' data that shows the problem?

It's the brief date range labelling that does this, it takes the month and the year of the first date in that interval.

Thanks for your updates Daniel. Can you please tell me what format do you use to show the above snipping...?

The date field was in "dd-MMM-yyyy" format,

the brief date labelling changed it to "dd(1) to dd(2), MMM(1)-yyyy(1)"

(1) - derived from the start date of the interval
(2) - derived from the end date of the interval


*Note I am using 2.9 so the date ordering issue has not changed but if I change the date format to "dd-MM-yy" the outcome is "dd(1) to dd(2), MM(1)-yy(1)"





Generally I avoid using the brief date labelling and just use a week commencing formula field which shows just the first date of the corresponding week. If you don't have to show the full week interval range (See attached Omniscope file). As long as your dealing with standard weeks of 7 days it's not hard to figure out.

Thanks for the response Daniel but my concern is if you see your above snipping of date grouping, my concern is when a week group is been done between 2 months or years it eventually captures "MM(1)-yy(1)" as per your note but its not right. Please find my example as attached. I have highlighted in yellow where it says "W1-14" which actually should be "W1-14". Please help me to fix this issue as all my charts are represently incorrectly.

You should have a formula field to create the labels exactly the way you want them to appear on the chart.

Hi Paola
Thanks for your suggestion but can you give me an example of grouping 2 days in a week and having the 2nd date's month and year?

Thanks
Rajesh

BUCKET([Date], 2, "day", "dd-MMM-yy")