Skip to Content
0
Former Member
Dec 02, 2011 at 02:20 AM

Chart (X) Axis date display not matching group display for start date

21 Views

Hello,

I have a report which groups by week with starting day monday and week ending sunday. The data is grouped off a formula

Formula: GroupWeekStartMon

 {zemptyrepo_.LgStrDt}-DayOfWeek ({zemptyrepo_.LgStrDt},crMonday )+1 

This works perfectly, the issue is current the report groups and shows the start date for the week (monday)

e.g

21/11/2011 $982928

14/11/2011 $298290

07/11/2011 $726727

The chart, which also uses Formula: GroupWeekStartMon displays

20/11/2011

13/11/2011

07/11/2011

Basicaly i need the chart dates to match the report dates..

any ideas?