Generate Broadcast Calendar

[#1]

I am currently in the process of building a QV application for a broadcasting company. All broadcasting companies (radio, tv, etc) uses a standard broadcast calendar. Has it's own begin and end dates for month, quarter and year.

Is there any one having a logic to generate broadcast calendar dates for a given year? I would like to use the logic instead of reinventing the weel.

Thanks,

Satheesh

[Anonymous]

Satheesh,
I don't know what the boradcast calendar is... See my post on Wiki How to Create a Calendar, maybe it can help.

[#3]

Mike,

All Radio stations and TV stations follow a standard calendar which is different from general calendar. For e.g. Broadcast calendar for 2009 begins 12/31/08 and ends 12/26/09.

JAN = 12/31/08 - 1/27/09

FEB = 1/28/09 - 2/24/09

MAR = 2/25/09 - 3/30/09 etc.

You can see and print the calendar through the software 'BCal.exe' which is available fee in the web. You can google for 'Standard Broadcast Calendar' to see calendars for some years.

My issue is to build a logic in QV to report on Week, Month, Quarter, etc. If you have any idea please help me.

Satheesh

[#4]

I would suggest that you create a Broadcast Dates table and put your broadcast information in there.

We use a Dates table that contains a record for every date. In that record, we have a standard date field, a week/year field, a quarter field, etc. Once you link your dataset to this Broadcast Dates table, you will be able to use any of those fields.

EDIT: Here's a quick sample:

Key Date Month Year Quarter Week
1 12/31/2008 1 2009 1 012009
2 1/1/2009 1 2009 1 012009
3 1/2/2009 1 2009 1 012009

[Anonymous]

Satheesh,
This is what I googled out:
"A standard broadcast week starts on Monday and ends on Sunday. The standard broadcast month ends on the last Sunday of the calendar month. "

Week in QV by default starts on Monday, so there is nothing special to do. If you define week by its start date, it will be
weekstart(DateId)) as Week
You can define month and year this way:
date(monthstart(weekstart(DateId)), 'MMM-YY') as Month,
year(weekstart(DateId)) as Year

[#6]

I have done the same using the excel and loaded into qvw. I was wondering for any possible automation without maintaining this sheet/table.

Thanks anyway.

[#7]

Thanks Michael. I will look into it.