Hello,
I’m having a small issue with a user who has a simple field in a Word template. The field looks like:
{ MERGEFIELD Appointment_Time \@ "MMM d h:mm am/pm" }
The value of the Appointment_Time field is stored in GMT. The user would like the value of the field to appear as his local time zone, but it shows as the value of the timezone in which our server is located (which happens to be 3 timezones ahead of the location of the user).
This seems like a similar problem to formatting numerical values according to Locale settings, but since the Locale setting (“en-US”) doesn’t contain timezone, Words naturally uses the timezone of the server.
Do you have a suggestion on how I can get Words to use the current user’s timezone (which I do have available in my data) in evaluating date/time fields?
Mike