Playing with TIME in a FMP D-base

[JackSparks]

Quick question: is there any way to change the clock settings on FMP. Here's the problem: the business I work in has a day starting at 6:00 am and ending at 5:59am on what would technicaly be the following day. Is there a way to format the database so that it recognizes this as the normal day (as opposed to the normal 12 to 12 day). I don't know if this needs to be a script or what. Any help would be greatful?

thanks,

jack

[Kundinger]

Hi Jack,

This is interesting... first I've heard of anyone wanting to alter a "day's" hours.

Here's an idea:

calc field "Correct Date" = 'activityTIME' - six hours

- or -

calc field "Correct Date" = 'activityTIME' + eighteen hours

Hope this helps!!!

Bob Kundinger

[JackSparks]

Thanks for the tip Bob. I'll check it out.

The reason for altering the hours deals with the difference between a normal day and a broadcast "day" . The DBase is for a TV network an a "Broadcast Day" starts at 6:00am and ends at 5:59am. So that means when I enter programming into the database I have to be able to put in the correct broadcast day and 1:00am. that means that a sorted list would be all messed up with programs that actually air that night, listing as if they aired earlier in the day. It's weird but what are you going to do?

Thanks for the help again and if anyone has any other suggestions that would be great.

Jack

[Geeksharka]

You could also create a table of Broadcast Days (BD), (sort of similar to 'Shifts'). You could still utilize an offset calc on Status(CurrentTime) in many scripts etc. like Bob suggests, but your Broadcast Days would always be clearly defined, cause each one is a record.

That way other items in your system could relate to any BD.

HTH