Changing date not at 00:00 but at 06:00 AM

[tapetv]

I work for a national radiostation that has some programs that are broadcasted 'over' and after midnight. In our schedules, these programmes still belong to the past day, but of course FM will correctly change the date after midnight. Is there a way to tell FM to change the date and day of the week at 06:00 AM??!

Any help is very very welcome, since this is a big brainer for all involved and can cause all kinds of misunderstandings.

[Damocles]

Judging by the question, do you use a 24 hour click to avoid the whole "AM/PM" issue? I'm assuming that you already keep track of "Program_Date" and "Program_Time". Create one more field, call it "Schedule_Date" or whatever makes sense to you. Make it a calculated field, with "Date" as the result.

Set the calculation: If(Hour(Program_Time)*60+Minute(Program_Time)<360, Program_Date-1,Program_Date)

This should work to let you know the programming date that the show STARTED. To find the Program_Date the show ENDED, insert the program run time in the calculation like this.

Set the calculation:

If(Hour(Program_Time)*60+Minute(Program_Time)+Run_Time<360, Program_Date-1,Program_Date)

This is written with FM6, and there may be a better way to do this in FM7, but I'm still on the old version. Also, you may have to convert the "," to ";" if you are using a different language version.

Hope this helps!

Paul