Adam,

Thanks. Yes, I was beginning to realise that a UDF is what's required
- I haven't yet had a go at UDFs so was hoping there might be an
easier way!

The server I'm running is Linux based, but I presume that there will
be ways of getting UTC, timezone setting & hence local time info from
Linux?

Will

>
> Hello Will,
>
> The solution is not simple, however it can be done using UDF's. If you
> are using a windows setup, the Timezone information can be read from
> the registry.
>
> The parameters I pass into the UDF function are the Timezone name and
> local time and it returns the gmt time as a timestamp. But it gets
> stored the same way as any other timestamp field.
>
> Adam