hi, i have a number of records of events that
need to be sorted according to the "actual" start
time, independent of time zone differences. i
have an "starttime" field (time format) that i
enter values into in 24h format, a UTC field, and
a calc field that i thought i could use to sort
the records, for e.g., events in:
city | time zone / UCT | local time (time) | montréal time (calc)
melbourne | UTC +10 | 12:00 | 22:00 (previous day)
berlin | UTC +1 | 05:00 | 23:00 (previous day)
london | UTC 0 | 05:00 | 00:00
montréal | UTC -5 | 13:30 | 13:30
berlin | UTC +1 | 23:00 | 17:00
vancouver | UTC -8 | 15:00 | 18:00
i'm getting some strange results in the calc
field, like 04:06:45 for an event in montréal...
i'm not terribly concerned with changes due to
daylight savings, but any options also including
that would also be appreciated.
cheers,
jef
