I need help for an unusual kind of report. I need to create a following kind of report. It can be in either csv or html format. Or perhaps if not possible in either of the two, then can you suggest some other format and how to get it. I need the logic - how to go about it, based on the date how do I get the day of the week and display it.
The report is something like -
Input to this report will be a date range.
Pl. note - all the text in bold will be a static text...I mean Room 1, Room 2, Room 3. And the dates should be displayed based on user input and their respective day of the week.
For e.g. the date range is Jan 3, 2005 - Jan 14, 2005. So, the report should look like -

January 2005
	Mon	Tue	Wed	Thur	Fri
	3	4	5	6	7
Room 1	Class A	Class A	Class A
Room 2		Class B
Room 3
	10	11	12	13	14
Room 1
Room 2
Room 3	Class C	Class C	Class C	Class C	Class C

---

---

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		&
	<		&lt;
	>		&gt;
	[		&#91;
	]		&#93;

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.