crosstab week-of-year

vpoojari

I am using week-of-year of datacube, which is working perfect, but the headers are the week of year in numeric. I want to show start and end date in the header for the week which would be more explanatory for the end user.


1 2 3

1500 9890 98990


26Jan-1Jan 2Jan-8Jan 9Jan-15Jan

1500 9890 98990

mcremer

<blockquote class='ipsBlockquote' data-author="'vpoojari'" data-cid="81998" data-time="1314535748" data-date="28 August 2011 - 05:49 AM"><p>
I am using week-of-year of datacube, which is working perfect, but the headers are the week of year in numeric. I want to show start and end date in the header for the week which would be more explanatory for the end user.<br />
<br />
<br />
1 2 3<br />
<br />
1500 9890 98990<br />
<br />
<br />
26Jan-1Jan 2Jan-8Jan 9Jan-15Jan<br />
<br />
1500 9890 98990<br /></p></blockquote>
<br />
<br />
You could use a java script on that dataobject somting like:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
// We know week number and year.
int week = 3;
int year = 2010;

// Get calendar, clear it and set week number and year.
Calendar calendar = Calendar.getInstance();
calendar.clear();
calendar.set(Calendar.WEEK_OF_YEAR, week);
calendar.set(Calendar.YEAR, year);

// Now get the first day of week.
Date date = calendar.getTime();
</pre>