1 Reply Latest reply on Jan 19, 2012 11:09 AM by philmodjunk

    BROADCAST CALENDAR - HELP!

    DanaStites

      Title

      BROADCAST CALENDAR - HELP!

      Post

      I need to be able to summarize by Broadcast Week.   A broadcast week runs Monday-Sunday, ending the last Sunday of the month.   For instance, the broadcast year of 2012 starts on 12/26/2011 and ends on 12/30/2012

      So I want week 1 to be 12/26/2011 - 1/1/2012; Week 2    1/2 - 1/8;  And so on.  

      I can get it to do what I want Sunday-Saturday, but I need it to be Monday-Sunday like a standard telelvision/ad agency broadcast calendar.

      Any suggestions?

        • 1. Re: BROADCAST CALENDAR - HELP!
          philmodjunk

          Can you explain what you want in more detail? Do you want a report of dates falling in a given broadcast week or ???

          You can use the dayofweek function to compute the date of the first and last days of a given broadcase week, but I don't know what you want to do with those dates once we've produced them.

          If ( DayOfWeek ( DateField ) = 1 ; Datefield - 6 ; DateField - DayOfWeek ( DateField ) + 2 )

          will compute the week start date for any date in datefield falling in the same broadcast week.

          StartDate + 6

          will then compute the end date of this interval.