On 09/09/2008, at 1:12 pm, jef chippewa wrote:
i'm getting some strange results in the calc field, like 04:06:45
for an event in montréal...
Sounds like your calculation is wrong, but you neglected to tell us
what it is.
Try this:
target_time = source_time + ( target_zone - source_zone ) * 3600
where source_time is a time (or timestamp) field, and target_zone/
source_zone are both number fields representing the time zones, which
you can adjust accordingly for daylight savings.
--
Tim Mansour <[EMAIL PROTECTED]>
